You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "Natu, Ashlesha [IT]" <as...@citigroup.com> on 2006/06/07 16:16:57 UTC
RE: Drop down list in excel
Sumit,
Thanks for your reply. I will try this. But I was thinking, would it be possible to save an excel template on the server which has the required drop down lists. Then when I want to write to the excel, I just open the template and set the cell values. I am not sure if this will work. I haven't tried it yet. I was just wondering if this could be another solution.
thanks & regards,
Ashlesha
-----Original Message-----
From: Sumit_Machwe@external.mckinsey.com
[mailto:Sumit_Machwe@external.mckinsey.com]
Sent: Tuesday, May 30, 2006 5:19 PM
To: poi-user@jakarta.apache.org
Subject: Re: Drop down list in excel
I think this question has been asked many times earlier.. and I think it
is not possible thru the available APIs (HSSF) as of now.
There is a hard way to do it though.. and might NOT be worth the effort..
but
you can create a macro to do this in a template xls and then create
instances from this template to get the desired results.
For example if you need a dropdown in C1 column of a sheet called
"Sheet1". And you know that the dropdown values are located at, lets say
Sheet2.A2:A10. Then you can write a macro which will triggered at a
particular event (lets say opening of the workbook), which will first find
out if there is a dropdown control in Sheet1.C1. If not then it will
create the control else do nothing. This macro can be at workbook level.
Regards,
Sumit Machwe
"Natu, Ashlesha [IT]" <as...@citigroup.com>
05/30/2006 03:15 PM
Please respond to
"POI Users List" <po...@jakarta.apache.org>
To
<po...@jakarta.apache.org>
cc
Subject
Drop down list in excel
Hello,
I am using Jakarta POI to write to an excel spreadsheet. I need to have a
drop down list box in a column in the excel sheet (like, Data - validation
, allow List, if it was to be done manually) .
Is it possible to do this with POI?
thanks & regards,
Ashlesha Natu
(908)563-0802
+=========================================================+
This message may contain confidential and/or privileged
information. If you are not the addressee or authorized to
receive this for the addressee, you must not use, copy,
disclose or take any action based on this message or any
information herein. If you have received this message in
error, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation.
+=========================================================+
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
RE: Drop down list in excel
Posted by Vipin Menon <vm...@enlighta.com>.
Hi,
I tried to take up this code on my machine but it seems giving lot of
compilation problem Like :
1. Constructor Record(short, short, byte[]) is undefined.
2. Constructor Record(short, short, byte[], int) is undefined.
3. The method createPtg(RecordInputStream) in the type Ptg is not applicable
for the arguments
(byte[], int)
etc to name few.
I took Nightly SVN Builds of Jakarta POI of 26th June but I was not able to
find the definition of above mentioned constructors and method in the source
as well.
Does I am doing something wrong or missing at same part, that need to be
done to get rid of the compilation problems?
With Best Regards,
Vipin Menon
-----Original Message-----
From: Sean Sullivan [mailto:sean@seansullivan.com]
Sent: Wednesday, June 07, 2006 7:56 PM
To: POI Users List
Subject: Re: Drop down list in excel
Bugzilla # 27511 contains source code that would enable data validation
lists in the POI API.
As far as I know, this code has not been integration into the POI project.
http://issues.eu.apache.org/bugzilla/show_bug.cgi?id=10214
http://issues.eu.apache.org/bugzilla/show_bug.cgi?id=27511
http://www.mail-archive.com/poi-user@jakarta.apache.org/msg03968.html
http://www.mail-archive.com/poi-user@jakarta.apache.org/msg05105.html
http://www.mail-archive.com/poi-user@jakarta.apache.org/msg05116.html
http://www.mail-archive.com/poi-user@jakarta.apache.org/msg03735.html
http://www.mail-archive.com/poi-user@jakarta.apache.org/msg03739.html
> "Natu, Ashlesha [IT]" <as...@citigroup.com>
> 05/30/2006 03:15 PM
> Please respond to
> "POI Users List" <po...@jakarta.apache.org>
>
>
> Hello,
>
> I am using Jakarta POI to write to an excel spreadsheet. I need to have a
> drop down list box in a column in the excel sheet (like, Data - validation
> , allow List, if it was to be done manually) .
>
> Is it possible to do this with POI?
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Drop down list in excel
Posted by Sean Sullivan <se...@seansullivan.com>.
Bugzilla # 27511 contains source code that would enable data validation
lists in the POI API.
As far as I know, this code has not been integration into the POI project.
http://issues.eu.apache.org/bugzilla/show_bug.cgi?id=10214
http://issues.eu.apache.org/bugzilla/show_bug.cgi?id=27511
http://www.mail-archive.com/poi-user@jakarta.apache.org/msg03968.html
http://www.mail-archive.com/poi-user@jakarta.apache.org/msg05105.html
http://www.mail-archive.com/poi-user@jakarta.apache.org/msg05116.html
http://www.mail-archive.com/poi-user@jakarta.apache.org/msg03735.html
http://www.mail-archive.com/poi-user@jakarta.apache.org/msg03739.html
> "Natu, Ashlesha [IT]" <as...@citigroup.com>
> 05/30/2006 03:15 PM
> Please respond to
> "POI Users List" <po...@jakarta.apache.org>
>
>
> Hello,
>
> I am using Jakarta POI to write to an excel spreadsheet. I need to have a
> drop down list box in a column in the excel sheet (like, Data - validation
> , allow List, if it was to be done manually) .
>
> Is it possible to do this with POI?
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/