I am trying to export information to excel and click format when exporting. When I open the Excel file I get a message to say: We found a problem with some content in Filename.xlsx. Do you want to try to recover as much as we can?
The error meaage is as follows-
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error913480_01.xml</logFileName><summary>Errors were detected in file 'C:\Users\braham.edwards\Downloads\Comms to Pay - Month 1(zMKPSJ) (1).xlsx' </summary><repairedRecords><repairedRecord>Repaired Records: Format from /xl/styles.xml part (Styles)</repairedRecord></repairedRecords></recoveryLog>
How do I find out what column is causing the problem?
error is indicates the problem is with the Styles defined in the Excel file's internal XML structure (/xl/styles.xml). This means the error is not related to the data in a specific column, but rather to a corrupted, invalid, or overly complex formatting rule applied to one or more cells.
Do you have any complex color coding and number formats ?
anyway try to export simple table chart and check.
Thanks Nagaraju, I do not have any complex colour coding, just a NUM() on a numeric field to limit it to 2 decimal points. I did export another table with a numeric field and it exported without a problem. Let me try with the formatting of the numeric function.
Is there a way of looking at Excel's XML structure?
Hi Nagaraju, I did some further testing and see that the column that was causing the issue was the date column. In Qlik Sense we define the format as DD/MM/YYYY, and export it in that format. My regional setting are set to display short dates as 'dd/MM/yyyy'. Any suggestions on these settings to resolve?
