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 ???