Excel styles are getting corrupted when processed using closedxml in C#

Question

Hi All,

 

I have an excel workbook with 14 worksheets. It have lots of tables and data. When I manipulate the excel using the closedxml the styles of the excel is getting corrupted. manipulation means hiding, inserting data etc. Even if the excel is just opened using closedxml and closed then also the excel styles are corrupting. When I open the excel it is prompting me to repair the excel with the below error message. Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.

Repaired Records: Table Style from /xl/styles.xml part (Styles)

Please ask if any more information needed This is very important for us. Please give any solution, idea and suggestion.

Answer 1

• Update ClosedXML: Make sure you're using the latest version of ClosedXML. Bugs related to style handling might have been fixed in newer releases. Check the official website for updates: https://www.nuget.org/packages/ClosedXML/
• Isolate the Issue: Try creating a minimal reproducible example. Create a new C# project with a simple workbook containing a few tables and data. Manipulate the workbook using ClosedXML and see if the styles get corrupted. This will help isolate if the issue is specific to your complex workbook or a general problem with your code.