search

linways / table-to-excel

Javascript library to create "valid" excel file from html table with styles
MIT License
226 stars 109 forks source link

How to add hyperlink? #1

Closed HelenDias closed 5 years ago

HelenDias commented 5 years ago

Hi! Anyone can help me? I have a HTML with my table and I'm using style classes in td and/or tr. I need to add a hyperlink on cell, but I don't find how to do that. Also, I will like to add more than one hyperlink at the same cell (td). Anyone have any example to help me?

rohithb commented 5 years ago

Added support for hyperlink with the latest version of SheetJS. Download latest version of linways/table-to-excel use data-link to specify the url. Eg:

<td data-link="https://google.com">
    <a href="https://google.com">Hyperlink</a>
</td>

Instead of using dist/xlsx_html.full.min.js, include latest version of SheetJS/js-xlsx along with dist/xlsx_html_utils.min.js and lib/FileSaver.min.js.

<script type="text/javascript" src="lib/FileSaver.min.js"></script>
<script type="text/javascript" src="https://raw.githubusercontent.com/SheetJS/js-xlsx/master/dist/xlsx.core.min.js"></script>
<script type="text/javascript" src="dist/xlsx_html_utils.min.js"></script>

Note that the styles will not work with the original version of SheetJS/js-xlsx.
I will try to add hyperlink support to protobi/js-xlsx so that styles will work along with hyperlinks.

gavinhungry commented 5 years ago

@rohithb,

Is there a fork available of protobi/js-xlsx that this module could use to support styles and links?

rohithb commented 5 years ago

@gavinhungry protobi/js-xlsx is not actively maintained, and I searched for its fork, unfortunately I couldn't find any.
So I'm re-writting the library to use guyonroche/exceljs as the backend, which supports hyperlinks, images and more. Its available under branch v2.

All the exsiting features are migrated and added support for hyperlink. You can use data-hyperlink to add hyperlink to a cell.

I had to change the function name to TableToExcel.convert, since we no longer use js-xlsx. The readme is not complete yet. Please refer this if required.

rohithb commented 5 years ago

Released v1.0.0 Change the backend excel library. Added support for hyperlink, border colors, exclude rows etc.