Export HTML Table to Excel using JavaScript

[@Cyndrex]

When exported to Excel, the columns are hidden. I have to unhide the columns every time. Know of a fix?

[@atharpanahi3563]

I converted my table with this script. But I have dates columns in my html table and they showed like #### in excel file. How can I fix it?

[@ericaimhigh]

That's probably because the data (date) is longer than the cell space. Increase the column width in excel and it should be fine

[@alvarorenteriaarce9146]

Y si tengo una tabla anidada como seria?

[@johnnyasumbra5817]

Hello why I am getting a date return instead of text in excel ?

[@InventionTricks]

retry it

[@mariorojas3054]

@@InventionTricks was this issue resolved? I'm facing same problem :(

[@miquelivanduarte425]

THANKYOUUUU 🤧🤧

[@NouarMohamedTakieddine]

can you do it in java

[@InventionTricks]

I have a JavaScript Developer

[@hichamloukili3910]

@@InventionTricks You can do it using POI in java

[@perderaluca9952]

Thank you it's amazing!

[@InventionTricks]

I'm glad you like it

[@davidwilson50901]

thanks

[@UsamaShah-jh1ew]

if a table has if and else condition how can we get (if condition first in one button and the else condition in another button)

[@bkcy18]

The plugin simply spits out the rendered table into a spreadsheet. The html table will be displayed in the page after your if-else logic is executed. And then you can select the table using any selector of your choice and pass it to the constructor.