how to export html table and append as a sheet in existing excel using javascript or jquery

Question

I am trying to export many html table as a single excel file and each html table in a new sheet.

how to export html table and append as a sheet in existing excel using javascript or jquery and how to rename the sheet ?

Check: http://stackoverflow.com/questions/22317951/export-html-table-data-to-excel-using-javascript-jquery-is-not-working-properl — Leandro Carracedo, Jan 15 '15 at 01:27

score 1 · Accepted Answer · answered Jan 15 '15 at 01:29

1

Ideally this kind of job can be easily done by VB or C#.

But if you really need to solve this by javascript, you can try this js lib.

Here is the documentation on how to add data to worksheet.

answered Jan 15 '15 at 01:29

joydesigner

Ok I will try this. Whether VB code can be integrated with PHP ? If so how it can be done in VB ? Kindly help me – svl Jan 15 '15 at 04:31
1

If you are using PHP, you can use PHP's csv function. http://php.net/manual/en/function.fgetcsv.php OR PHPExcel. https://github.com/PHPOffice/PHPExcel – joydesigner Jan 15 '15 at 04:55

1 Answers1