Hi, Everybody,
In my current application, in one of the page a list of summary report is loaded.As the count increases,loading of the page becomes very sloow and gives a big performance headache.
Hence now decide to go for exporting the data in to an excel.If it is, can any of you please recommend a standard API which is used for this kind of task.A sample code will be of much help.
Thanks
Vishy
> You mean to set the response content type to Excel
> and do a printwriting on that file ?
> Is this hte option you are suggesting ?
No. You stated, "Hence now decide to go for exporting the data in to an excel."
Microsoft Excel has the ability to read CSV and tab-delimited files. Simply write out your data into a plain text file as such.
I have a feeling that you will be needing the following:
http://java.sun.com/docs/books/tutorial/essential/io/
Look for the jakarta poi (HSSF) project:
http://jakarta.apache.org/poi/hssf/index.html
(This is like the third time I post this today, what's going on with excel exports, becoming very popular?)
Another and very simple option is to export as a CSV file which is a comma seperated values file. Can be exported into excel.
http://en.wikipedia.org/wiki/Comma-separated_values
> Look for the jakarta poi (HSSF) project:
The main reason I did not not mention this to the OP is because of the KISS rule.
>
> Another and very simple option is to export as a CSV
> file
The CSV and TDV file types were suggested in reply 1.
The Excel/IDE/CLASSPATH/String equality/insert common problem here questions are cyclical with a periodicity of, oh...several MINUTES! N00bies who can't bother to use their gray matter.
