I am novice to JSP, can anybody please send me code how to export htaml
page table content into excel file.
Thanks in advance.
Andy Dingley - 11 Oct 2006 14:02 GMT
> I am novice to JSP, can anybody please send me code how to export htaml
> page table content into excel file.
Generate absolutely minimal HTML with the right structure and no
superfluous boilerplate on it. Cut and paste into Excel.
It's easy (really easy). Just don't trap yourself into thinking it must
be hard.
Let Excel do the work for you by using its good abilities to read HTML.
Trying to make a web protocol fit around Excel would be much harder,
especially as Excel doesn't have any well-defined standards for its
formats.
Mike Beaty - 11 Oct 2006 15:01 GMT
Here are a couple of options if you want to auto-generate an Excel file
from your Java code. One would be to create a simple CSV download and
then open with Excel. It would be a basic layout without colors or
formatting. Another option would be to use the Jakarta POI API. You
can read and create Excel files using this API. I've never used it,
but it looks pretty simple: http://jakarta.apache.org/poi/
-Mike
> I am novice to JSP, can anybody please send me code how to export htaml
> page table content into excel file.
> Thanks in advance.