efficient way to create a xls file in a jsp page
what is the most efficient way to create a xls file in a jsp page?
I created an xls file using p开发者_开发技巧oi in jsp page, but if not the most efficient.
Thanks
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
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.
精彩评论