Loading File with Formular Error

[TobyNeu]

Hi @all,

I need to load a xlsx-File supplied by one of our customers.

This File has a formular error on the 3. Sheet. If I open the File in Excel ith shows "n/a" for the error-cells but when i try to oben the file with Spire.XLS an exception is throws.

Is it possible to to load the file - like excel does - with n/a in the cells or skip the error-worksheet(s)?

Thank you
Tobias

[sweety1]

Hello,

Thanks for your inquiry.
Could you please offer us your sample excel file?
It would be helpful to replicate the issue and work out the solution for you ASAP.
If the information is confidential, you can send it to us ( Support@e-iceblue.com ) via email.

Best Regards,
Sweety
E-iceblue support team