search

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

Remove decimal values / showing all values decimal #352

Closed vinaysavner closed 2 years ago

vinaysavner commented 2 years ago

Why every values are exporting in decimal format. I am exporting the excel sheet.

denilsonsa commented 2 years ago

Very rude to tag a bunch of people who haven't touched this project in five years. You wanted attention, but you got the wrong type of attention.

Please do not tag random people without a good reason. I haven't used this project in 5 years. I cannot help you with your problem.

You could try these:

hhurz commented 2 years ago

@vinaysavner You didn't write into which excel format you want to export to. For xls (Excel 2000) you can find a solution at the end of this issue: #156

vinaysavner commented 2 years ago

~Very rude to tag a bunch of people who haven't touched this project in five years. You wanted attention, but you got the wrong type of attention.~

Please do not tag random people without a good reason. I haven't used this project in 5 years. I cannot help you with your problem.

You could try these:

Thanks for providing me this important contents and sorry for the tag bunch of people, actually that time I need to fixe this issue asap possible.

vinaysavner commented 2 years ago

Hi, I am using xlsx format and you will be glad to know that I have done it. But recently i want to do some styles in the XLSX format, I want to add BG colors in some cell's. Can you please suggest me a good this to do this. Thanks.

Hi, I am using xlsx format and you will be glad to know that I have done it by changing the numbers value in mso object.

var defaults = { mso: {
xslx: {
formatId: {
numbers: 1, // Changed this to 1 and decimal values are remove } }, Thanks.