topic Re: Exporting a table to Excel in App Development

Exporting a table to Excel

braham — Fri, 14 Nov 2025 06:50:48 GMT

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?

Re: Exporting a table to Excel

Nagaraju_KCS — Fri, 14 Nov 2025 07:19:13 GMT

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.

Re: Exporting a table to Excel

braham — Fri, 14 Nov 2025 07:34:25 GMT

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?

Re: Exporting a table to Excel

braham — Fri, 14 Nov 2025 11:02:22 GMT

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?

Re: Exporting a table to Excel

Nagaraju_KCS — Fri, 14 Nov 2025 11:20:32 GMT

Try this

Change the date format as text using Dual function in the script

Dual(Date(DateField, 'DD/MM/YYYY'), DateField) AS DateField

Re: Exporting a table to Excel

braham — Fri, 14 Nov 2025 12:22:39 GMT

Hi Nagaraju, thanks for formatting of the date field works.