Beejal, 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. Regards, Jeenus.
________________________________ From: Beejal [mailto:[EMAIL PROTECTED] Sent: Tue 2/19/2008 7:09 PM To: 'Jakarta Commons Users List' Subject: FW: Problem displaying dropdown in excel _____ From: Beejal [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 7:09 PM To: 'Jakarta Commons Users List' Subject: Problem displaying dropdown in excel Hi, 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? Regards, Beejal http://www.patni.com <http://www.patni.com/> 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 [EMAIL PROTECTED] and delete this mail. _____________________________________________________________________
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
