Error message "Recovered Records: Style from /xl/styles.xml part"

[tinywolf]

Hello.

I had saved a xlsx file using XlsIO.

But, this file had an error message.

"Excel found unreadable content in '???.xlsx'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."

After clicking Yes, then another error appeared saying:

"Excel was able to open the file by repairing or removing the unreadable content.
Repaired Records: Style from /xl/styles.xml part (Styles)"

How to fix it?

Attachment: test_20210511_021324_a64b5fd6.7z

[Konduru Keerthi Konduru Ravichandra Raju]

Hi tinywolf, 

Greetings from Syncfusion. 

We have analyzed the Excel document you have shared us and found that the Excel is corrupted due to the number formats applied for worksheet cells. So, please share us information about the number formats applied in the worksheet cells along with the full code snippet to create the shared Excel document using flutter_xlsio package which will be helpful for us to investigate further on this. 

Regards, 

Sridhar. 

[tinywolf]

Thank you for such a quick reply.

Here is my flutter code.

https://pastebin.com/7g4x2VaC

[Konduru Keerthi Konduru Ravichandra Raju]

Hi tinywolf, 

 

We have analyzed your shared codes and found that you have used these two number formats (“#,##0.00_”, “#,##0_”) in your code. Those two number formats are not valid in MS Excel. When we try to apply these number formats, MS Excel throws “Microsoft Excel cannot use the number format you typed” exception. 

 

So, we request you to use these two (“#,##0.00”, “#,##0”) formatting strings instead of those invalid number formats to resolve the issue. Please try it in your application and let us know whether the issue is resolved at your side. 

 

Regards, 

Sridhar.