commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeenus Johnson" <>
Subject RE: Problem displaying dropdown in excel
Date Tue, 19 Feb 2008 13:52:09 GMT
Haven't worked with JExcel API , just happen to google for the problem specified ,however
the suggested approach seems to be using macros .Please find attach sample java code which
may be a work around for your problem.


From: Beejal []
Sent: Tue 2/19/2008 7:09 PM
To: 'Jakarta Commons Users List'
Subject: FW: Problem displaying dropdown in excel


From: Beejal []
Sent: Tuesday, February 19, 2008 7:09 PM
To: 'Jakarta Commons Users List'
Subject: Problem displaying dropdown in excel


I am trying to populate the values in a dropdown in the excel file.

I am using jExcel API.

I have 74 String values to be populated in the dropdown.

The problem is if I add 5-7 values, excel file is generated properly with
the dropdown.

But if I try to add more than that, the dropdown is visible in the excel
sheet without any values populated.

I think that there is some buffer size fixed for each cell in the excel.

As soon as the values in the list exceed that buffer size, it gives problem.

This is one of the mandatory requirements in my project to populate the
values in the dropdown.

Is there any workaround for this problem?


Beejal <> 
World-Wide Partnerships. World-Class Solutions.

This e-mail message may contain proprietary, confidential or legally
privileged information for the sole use of the person or entity to
whom this message was originally addressed. Any review, e-transmission
dissemination or other use of or taking of any action in reliance upon
this information by persons or entities other than the intended
recipient is prohibited. If you have received this e-mail in error
kindly delete  this e-mail from your records. If it appears that this
mail has been forwarded to you without proper authority, please notify
us immediately at and delete this mail.

View raw message