Repository files navigation

Export HTML table to valid excel file effortlessly.This library usesexceljs/exceljs under the hood to create the excel.
(Initial version of this library was usingprotobi/js-xlsx, it can be foundhere)

Just add a script tag:

<scripttype="text/javascript"src="../dist/tableToExcel.js"></script>

npm install @linways/table-to-excel --save

importTableToExcelfrom"@linways/table-to-excel";

Create your HTML table as normal.
To export content of table#table1 run:

TableToExcel.convert(document.getElementById("table1"));

or

TableToExcel.convert(document.getElementById("table1"),{name:"table1.xlsx",sheet:{name:"Sheet 1"}});

Checkthis pen for working example.

Cell types can be set using the following data attributes:

Example:

<!-- for setting a cell type as number --><tddata-t="n">2500</td><!-- for setting a cell type as date --><tddata-t="d">05-23-2018</td><!-- for setting a cell type as boolean. String "true/false" will be accepted as Boolean--><tddata-t="b">true</td><!-- for setting a cell type as boolean using integer. 0 will be false and any non zero value will be true --><tddata-t="b">0</td><!-- For adding hyperlink --><tddata-hyperlink="https://google.com">Google</td>

All styles are set usingdata attributes ontd tags.There are 5 types of attributes:data-f-*,data-a-*,data-b-*,data-fill-* anddata-num-fmt which corresponds to five top-level attributesfont,alignment,border,fill andnumFmt.

BORDER_STYLES:thin,dotted,dashDot,hair,dashDotDot,slantDashDot,mediumDashed,mediumDashDotDot,mediumDashDot,medium,double,thick

To exclude a cell or a row from the exported excel adddata-exclude="true" to the correspondingtd ortr.
Example:

<!-- Exclude entire row --><trdata-exclude="true"><td>Excluded row</td><td>Something</td></tr><!-- Exclude a single cell --><tr><td>Included Cell</td><tddata-exclude="true">Excluded Cell</td><td>Included Cell</td></tr>

Column width's can be set by specifyingdata-cols-width in the<table> tag.data-cols-width accepts comma separated column widths specified in character count .data-cols-width="10,20" will set width of first coulmn as width of 10 charaters and second column as 20 characters wide.
Example:

<tabledata-cols-width="10,20,30">  ...</table>

Row Height can be set by specifyingdata-height in the<tr> tag.
Example:

<trdata-height="42.5"><td>Cell 1</td><td>Cell 2</td></tr>

Migration Guide for migrating from V0.2.1 to V1.0.0

• Changed the backend to Exceexceljs/exceljslJS
• Added border color
• Option to set style and color for all borders
• Exclude row
• Added text underline
• Added support for hyperlinks
• Text intent
• RTL support
• Extra alignment options
• String "true/false" will be accepted as Boolean
• Changed border style values
• Text rotation values changed

• Fixed bug in handling multiple columns merges in a sheet

• Option to specify row height