JSP to Excel loading

[damerlaroja]

We are trying to export data from jsp to excel using
response.setContentType("application/vnd.ms-excel");
But after export, the file size(85MB) is becoming 10times more than the
normal excel(8MB, When copied the data manually).
But even after saving the file, we are not able to open the excel file.


Any help in this regard is highly appreciated.

 

[Tor Iver Wilhelmsen]

But after export, the file size(85MB) is becoming 10times more than the
normal excel(8MB, When copied the data manually).

How do you send it? Normally you would just tab-separate the values, e.g.

out.println(value1+"\t"+value2+"\t"+value3)

etc.

 

[Oliver Wong]

We are trying to export data from jsp to excel using
response.setContentType("application/vnd.ms-excel");
But after export, the file size(85MB) is becoming 10times more than the
normal excel(8MB, When copied the data manually).
But even after saving the file, we are not able to open the excel file.

Any help in this regard is highly appreciated.

Sounds like you're dumping random data in the response. The fact that
the file is the wrong size and is corrupt is a good indication.

Have you tried opening the corrupt file in a hex editor to see what's
being produced?

- Oliver

 

[Joan]

We are trying to export data from jsp to excel using
response.setContentType("application/vnd.ms-excel");

Is that all you have to do is set the type in the header?
Hay then I can read a dll and write a png, cool.

 

[Swathi]

Hi,

We are using table format to display the values.