umya-spreadsheet icon indicating copy to clipboard operation
umya-spreadsheet copied to clipboard

Error when trying to read Excel file

Open harmbuisman opened this issue 1 year ago • 2 comments

When I read this Excel file from this github using umya_spreadsheet::reader::xlsx::read(filename) I get the following error:

...cargo\registry\src\index.crates.io-6f17d22bba15001f\umya-spreadsheet-1.2.7\src\structs\vml\text_box.rs:51:9:
Error at position 3638: EndEventMismatch { expected: "br", found: "font" }

The Excel file works fine when opening it from Excel.

After removing the sheet called "log", the file can be read using umya_spreadsheet::reader::xlsx::read(filename)

harmbuisman avatar Jun 06 '24 20:06 harmbuisman

@harmbuisman Thank you for contacting us. The error is probably for the same reason as #189. We will address this in the next version update.

MathNya avatar Jun 07 '24 08:06 MathNya

The latest version is now available. This version resolves the import error, but does not support form controls, Form controls are not supported. (They are lost when writing.)

Support for form controls will be considered in the next version.

MathNya avatar Jul 06 '24 00:07 MathNya