Search code examples
openoffice.org

what are the other setting need to see a html table into excel sheet format in open office org?


I have generated a html table from my web application and save the table into .xls format(in a single word i am generating a .xls sheet from my web application ).

What other setting I have to show it in table form.


Solution

  • It's not really saving as a .xls file -- it appears to be saving as the HTML, but with a .xls extension. How are you generating the .xls? On the server-side, you can provide a button to generate .xls directly (different methods depending on your server platform -- using perl there is the Spreadsheet::WriteExcel module that writes .xls directly, using Java there is JExcel (http://jexcelapi.sourceforge.net/ and POI (http://poi.apache.org/)), other platforms will have their methods.