Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

outputing a jsp page in excel format  RSS feed

 
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
Posts: 66199
151
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!