Please help me...
I am using office 2007 and with xlxs format
The list which is being displyed on page ..I am trying to save it In Excel wih POI.
Servlet code is saving the data in excel to the destination in xlxs format
but In jsp when i try to open it directly in excel sheet after clicking on open button. It is giving message,
Excel cannot open the file DistributionCalendarDownload.xlxs because the file format and file extention is not valid.
Varify that the file has not been currupted and that the file extention matches the format of the File.
Yes file is not currupted and extention is valid
but excel is opening with .xls format but not in .xlsx format
when i am changing .xlxs in jsp in setContent Type it is giving the below message
Excel cannot open the file ABC.xlsx because the file format and file extention is not valid.
Varify that the file has not been currupted and that the file extention matches the format of the File
What you need to verify is that the data that gets stream from the web app is byte-for-byte identical to the file that you originally put on the server. Unless that's the case, all other speculation is pointless.
Does that mean you have by now verified that what you stream from your servlet to the browser (and, as I said, you must use a servlet, you can't use a JSP) is a byte-for-byte identical copy of the original file? How did you do that?