Hi, we are using Aspose and it works great. Love it. But, one pretty simple thing we do is allow customers to download any report data as Excel. We do this by simply generating the JSON file and using Aspose to convert this to Excel. That works well, except when the JSON includes a date. Obviously JSON doesnt really have a date format, so these columns in the JSon file are strictly just strings. This means the resulting excel has a string column instead of a date/time column. You cannot then format this, or use any formulae or even sort by it in the resulting Excel file. Is there some special format we can use in the JSON file that will allow Aspose to recognise the data as a date/time and populate the excel file correctly?
The data we are supplying at the moment is a UTC format like this “2018-12-28T00:31:28.125412Z” - is that the issue? (given that excel doesnt seem to have any concept of UTC?
Or is there something else we should be doing?