• 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
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

JSP to Excel sheet

 
Ranch Hand
Posts: 67
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi guys,
Please help me out....

I have a jsp with a table. when I click on the "import to excel button" it has to create an excel sheet of the table. Currently I am doing it this way

create a string buffer and append the contents of the table to it
eg:
sbCsv.append( sPub + " " + sIssueMonth + " " + sIssueYear + " Forecast Report \n" );
sbCsv.append("Sales" + "\t" );
sbCsv.append("Ran Last Year" + "\t" );
sbCsv.append("Pages 100%-90%" + "\t" );
sbCsv.append("Pages 75%" + "\t" );
sbCsv.append("Pages 50%" + "\t" );
sbCsv.append("Pages 25%" + "\t" );
sbCsv.append("Forecast" + "\t" );
sbCsv.append("Forecast Last Week" + "\t" );
sbCsv.append("\n");

Then writing this to the excel sheet. Is there a better way to do it ???
 
Bartender
Posts: 2856
10
Firefox Browser Fedora Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
This topic has been discussed before
try searching the forum and
check this.

Hope this helps
 
Sahana Hegde
Ranch Hand
Posts: 67
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yes that helped.....tried something on similar lines.
Thanks. I appreciate it.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic