Problem when exporting to excel, <thead> does not keep empty space and changes it to 0.

hhurz / tableExport.jquery.plugin

jQuery plugin to export a html table to JSON, XML, CSV, TSV, TXT, SQL, Word, Excel, PNG and PDF

MIT License

984 stars 714 forks source link

Problem when exporting to excel, <thead> does not keep empty space and changes it to 0. #374

Closed RodrigoEscAlm closed 5 months ago

RodrigoEscAlm commented 8 months ago

Good morning,

I am making a table to export to excel, and when exporting the white spaces in the <theat> are converted to 0

I attach images of the table configuration and how it is displayed in Excel.

Thead declaration has the table-dark class "<thead class='table-dark'>"

and the values are displayed like this: '<tr >' '<th > <h6> valueName: '+value+"</h6></th>"; "</tr>" When I want to leave a free space: "<th></th>"; In Excel a 0 will appear in that cell.

Thanks in advance.

excel problem thead problem

hhurz commented 8 months ago

Hello, your problem cannot be reproduced without further information. In particular, the html code would be required to be able to make further statements. There is an example cssExcel.html in the test directory of this project. If you leave the elements empty here, Excel will also display empty cells and no 0 values.