I have a download functionality in my program that opens an excel sheet on click of a button on the JSP. How can I specify the name of the excel through servlet when the document opens? Also I want to give different names for the worsheets inside the excel sheet,how do I do that? Please help me in this since I have no idea about this.
Thanks in advance.
Archana Honnavalli wrote:Yes Apache POI works great for both xls and xlsx files.
I am using this jar to extract each cell value.
However cells with custom defined styles other than "General" will pose some challenges while extracting values. So be a lil careful.
Thanks for mentioning that. However, I noticed this behaviour during the implementation.