Hi there,
I am calculating four attributes related to date using attribute creator and then I use Datefromatter to convert those attributes into the desired format (i.e. %y%m%d). When I write those attributes into CSV file, I found that the cell format of those attributes is still 'General'. It didn't change to the date format. Could anyone guide me on how to fix the issue?
The CSV format does not have other data types than character.
If you would like to be able to define the cell format, I suggest using the Excel writer instead of the CSV writer.
That allows for more formatting of the attributes.
Hope this helps.
The CSV format does not have other data types than character.
If you would like to be able to define the cell format, I suggest using the Excel writer instead of the CSV writer.
That allows for more formatting of the attributes.
Hope this helps.
Thanks for reply. I tried with the excel writer. But the problem still exisit. Still the format of attributes are "general" instead of date.
Thanks for reply. I tried with the excel writer. But the problem still exisit. Still the format of attributes are "general" instead of date.
Using the Excel writer, you can write to a template.
If you have an empty template, with only the headers, you can set the type of the column.
The template will define how the data is stored in that case.
Hope that helps.