File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Other Open Source Projects and the fly likes Java POI Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Java POI" Watch "Java POI" New topic

Java POI

Vinod Nair

Joined: Jul 26, 2008
Posts: 1
i need to create an excel sheet list validation on cell and drop down list should contain the custom values

I tried using DataValidation, but I need to specify range of value

Is there any way i can give custom values in the list as in the excel sheet
Data->validation->Allow:List ?

Is this feature available in any other java API which create excel sheet?
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63854

"vicki", please check your private messages for an important administrative matter.

[Asking smart questions] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: Java POI
jQuery in Action, 3rd edition