Text Field Translated into Date when Exported to Excel
Article Number: 000004098 | Last Modified: 2018/06/12
Excel does a fair amount of auto-formatting to imported data. So, if you're trying to import the selection "1/2/8" Excel will read this as "01/02/2008". You may not wish for this auto-formatting to take place.
You can export the value as text using "ExcelExportMixedAsText = 1". This can be set in the Easter Egg settings of QlikView Developer or in the Settings.ini of QV Server. The Easter Egg settings of QlikView Developer can be found in Help > About QlikView > right-click on the Q in the lower left-hand corner. The Settings.ini for QlikView Server is found in the ProgramData/QlikView Server folder. You will need to stop the QVS service, add the setting to the Settings.ini, save, then restart the QVS Service.
This, though, only works when doing an "Export to Excel" under 65k rows as the data is put into an XLS file. If you do a simple "Export..." or export over 65k rows the data will be put into a CSV file. A CSV file retains no data formatting, so Excel will go on to auto-format the data as it usually does.
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.