Export to Excel from table or data table

Question

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.

Check this out for export to excel i dont know how to handle the formula part: codepen.io/kostas-krevatas/pen/mJyBwp — Dennington-bear
– Dennington-bear, Commented Sep 22, 2017 at 13:33

user1860166 · Accepted Answer · 2017-09-22 14:15:37Z

1

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

answered Sep 22, 2017 at 14:15

user1860166

2382 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Export to Excel from table or data table

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related