Hello, what is the most efficient way to create a xls file in a jsp page?
I created an xls file using poi in jsp page, but if not the most efficient.
Thanks
+2
A:
A lot of times when I need to make an xls file, I create a CSV file instead and use that to generate the XLS. Obviously, creating comma-separated values is very simple and importing / opening a plain-text CSV file as an Excel document is equally easy.
I hope that helps in some way,
--gMale
gmale
2010-07-09 23:46:43
+1 - CSV FTW :)
Russ Cam
2010-07-09 23:55:18
Since the guy uses POI, CVS may not be sufficient for his needs already...
Vladimir Dyuzhev
2010-07-10 03:37:25
He might not be aware about the ease of CSV.
BalusC
2010-07-10 03:43:13
thanks !!, But when the user opens the file as xls not see with commas?
Maria José
2010-07-10 03:44:21
no commas; but sometimes it's tricky to make Excel to show strings of specific formats as strings -- it "intelligently" converts them into dates, or numbers.
Vladimir Dyuzhev
2010-07-10 03:48:15
gmale
2010-07-10 04:05:56
thank you very much!!!!
Maria José
2010-07-10 11:59:55
A:
For cases more complex than CSV can handle (e.g. colourful formatting) I generate XML-based XLS file, which is very simple, almost like writing out HTML.
I never studied the format. Instead, I manually create the file in Excel, save it as XML, and write a code that produces a file of the same structure.
Vladimir Dyuzhev
2010-07-10 03:36:14