S
Sandrine
Hello,
I would like to open Excel using Java in a jsp.
There is an easy way to open Excel, to create a new worksheet and to
fill it with an HTML table, using:
response.setContentType("application/vnd.ms-excel");
But this way is not sufficient if you want to use other Excel
functionnalities (modify the rendering type for a cell, the color of
the cell...) and it is the case for me...
I found an API (poi - Jakarta project) that enables a programmer to
manipulate Excel documents (creation, reading, modification...), to
modify the cell properties in the document mais I don't know how I
can, using this api, open Excel and vizualise my document I created
with poi. But the created worksheet is still empty.
And if I use
response.setContentType("application/vnd.ms-excel");
I don't know how to fill my Excel document with the poi api and not an
html table.
Any suggestions would be appreciated.
Thanks in advance...
Sandrine.
I would like to open Excel using Java in a jsp.
There is an easy way to open Excel, to create a new worksheet and to
fill it with an HTML table, using:
response.setContentType("application/vnd.ms-excel");
But this way is not sufficient if you want to use other Excel
functionnalities (modify the rendering type for a cell, the color of
the cell...) and it is the case for me...
I found an API (poi - Jakarta project) that enables a programmer to
manipulate Excel documents (creation, reading, modification...), to
modify the cell properties in the document mais I don't know how I
can, using this api, open Excel and vizualise my document I created
with poi. But the created worksheet is still empty.
And if I use
response.setContentType("application/vnd.ms-excel");
I don't know how to fill my Excel document with the poi api and not an
html table.
Any suggestions would be appreciated.
Thanks in advance...
Sandrine.