CODEWITHSUNDEEP
javascriptjquerydatatableexport-to-excel
Hemanthkumar Rajan
Hemanthkumar Rajan

Reputation: 109

Export to Excel from table or data table

We have a requirement to export data in to excel from table, after export user will enter values in empty cell, that cell value will be added with another cell and it will display in the formula column.

For example:

<table border="1">
  <tr>
    <th>Column 1</th>
    <th>Column 2</th>
    <th>Formula Column</th>
  </tr>
  <tr>
    <td>10</td>
    <td>20</td>
    <td>30</td>
  </tr>
  <tr>
    <td>20</td>
    <td></td>
    <td></td>
  </tr>
</table>

In the above example after exporting, column 1 and column 2 value is empty for some rows. In the excel user will enter the values, after that the formula column should populate the sum.

Upvotes: 0

Views: 346

Answers (1)

user1860166
user1860166

Reputation: 238

Please see SheetJS, a JavaScript library to read and write spreadsheets.

Upvotes: 1

Related Questions