Help coderanch get a
new server
by contributing to the fundraiser
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Devaka Cooray
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Tim Moores
  • Carey Brown
  • Mikalai Zaikin
Bartenders:
  • Lou Hamers
  • Piet Souris
  • Frits Walraven

Saving jsp output to a Excel File in different tabs

 
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi
I have a way of saving the output generated from a JSp file into to a excel file by modifiying the Headers. The code looks like this
String fname=abc.xls
response.setContentType("file_content_type);
response.setHeader("Content-disposition","attachment;filename="+fname)
The output is saved to a Excel file abc.xls
IT THERE A WAY TO SAVE THE OUTPUT IN DIFFERENT TABS IN THE EXCEL FILE.
For example : Output1 - to be saved in abx.xls on excel tab TAB1
Output2 - to be saved in abc.xls on excel tab TAB2
and so on
Please help me
 
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You might want to check out
Jakarta POI
 
Author
Posts: 245
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
that is absolutely fantastic, seriously - thanks for the tip. btw, a simpler method might be possible to implement using MIME? it might be that if you send multiple documents back it will pick them up seperately. CSV by itself does not have an automatic way to page contents, in which case you will need to look at an alternative. If you are not sure how to try this out, then it might be simpler to just learn POI because it would require some experimentation.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic