How can the datatype of fields be controlled while exporting to Excel?
How can the datatype of fields be controlled while exporting to Excel?
odungern
Posts: 1Questions: 1Answers: 0
We are trying to export the data to CSV and XLSX. The former works pretty fine, while the latter gives us some headache having a column with chapter numbers (1, 1.1, 1.1.1). In this column, the content is apparently considered a number, so "1.1" is transformed to "1,1" according to the Excel locale and "1.1.1" creates an error which Excel will 'repair' after a confirmation. We would like everything to be treated as a string.
We have figured out that it is possible to get the data to export to apply some custom processing, but we haven't found anything to control the data-types.
Has anybody a hint, before we dig into the code or start to build our own excel export?
Any help is greatly appreciated.
This discussion has been closed.