Update - a workaround is to use another package such as spreadsheet_decoder in case of excel package errors. I can decode the excel sheet normally with the other package, extract the data, and ...

Excel Type XLSX XLSM CSV OTHER MiniExcel Version: 1.30.0 Description: I used the same example from the documentation, however the described ( Excel Dimension Xml is null )error occurs.

Excel provides a few functions that let you handle errors your way. To customize the performance of the automatic formula checking feature, click the Office button and choose Excel Options.

Learn how to use of the coalesce operator in Power Query and Excel to handle null values efficiently. These Practical examples and comparisons ...