TableExport icon indicating copy to clipboard operation
TableExport copied to clipboard

Date Conversion Issue

Open subrat7 opened this issue 7 years ago • 5 comments
trafficstars

Hi

I am using Tableexport version(5.0.0),i have date in the table and while export to excel i am facing below issue

Html table data image

and excel data is image please help me how to resolve this issue,Thanks in Advance

subrat7 avatar Feb 19 '18 10:02 subrat7

Now I'm thinking this could be related to what I mentioned in https://github.com/clarketm/TableExport/issues/124#issuecomment-376320828

joaociocca avatar Mar 26 '18 21:03 joaociocca

Before you call an instance of TableExport to the following: TableExport.prototype.typeConfig.date.assert = function(value){return false;}; I had a similar issue with P.O. Box numbers being converted to dates.

StuffieStephie avatar Jul 17 '18 18:07 StuffieStephie

I've had a similar problem with text that was being converted to date without reason. But @StuffieStephie answer fixed my code, thanks a lot!

soubrunorocha avatar Aug 03 '18 21:08 soubrunorocha

yeah - I just disabled it trying to convert dates as well as described by @StuffieStephie

nowherenearithaca avatar Sep 19 '18 21:09 nowherenearithaca

Hi,

I am having the same issue in date conversion. It seems that solution from StuffieStephie is working for all, however, I am a bit confused where to add this in the code. My code looks like below.

$(function(){ $('#').tableExport({ formats: ["xlsx", "csv"], bootstrap: true, sheetname: "sheet1", position: top, ignoreRows: null }); });

barman-a avatar May 28 '19 14:05 barman-a