• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

outputing a jsp page in excel format

 
deepa mc
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I set the content type of my jsp page to ms-excel and it is opening in excel too , but i don't see the rows and columns..i see it only after i change the format cells of the ms-excel ..Is there any way i could see it as soon as i see the excel page without manually formatting it?
Thanks in advance,
Deepa
 
Ruilin Yang
Ranch Hand
Posts: 150
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It looks like you need to put the format inf. when you call the excel.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65129
92
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you output the data as an HTML table, Excel will interpret it as the rows and columns of the spreadsheet.
hth,
bear
 
Trish Wu
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can also try and use Jakarta POI.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic