Issue while Reading getting an exception Found invalid data while decoding.

[SantoshRautTR]

Hi @MarkPflug ,
We are getting an exception(Found invalid data while decoding) while reading the attached excel sheet. if we open and save the same excel we are not getting the exception.
we are using Syslvan.Data.Excel version 0.3.2. Can you please check the attached excel and help on resolving the issue.

[MarkPflug]

Fixed with version 0.4.3, just pushed to nuget.

[MarkPflug]

@SantoshRautTR Do you happen to know what tool created that xlsx file? The structure of it looked a bit odd to me. Not anything that I'd consider broken, but definitely not something I'd expect Excel to create.

[SantoshRautTR]

@MarkPflug we will try to find out the tool used for creating the .xlsx file.

[Mek7]

We have the same problem with attached file.
1.1. Hours and expenses per customer 2023-06-28.xlsx
The XLSX file was generated by assembly Assembly Microsoft.ReportViewer.WebForms which is part of Microsoft.ReportingServices.ReportViewerControl.WebForms nuget package by Microsoft.
We are not using this nuget package in ASP.NET as a web forms component, but only call the method Report.Render("EXCELOPENXML"); of the Report class. It also has capabilities to export to DOCX and PDF.