Pull fails when Excel file contains formulas

[bjoernsteinhagen]

Description:

• I read in an Excel file, which previously worked fine. The file has very simple formulas.
• With the latest version of BHoM (7.2.0.240424), the pull fails.
• I copied all text within the Excel file and pasted the data again just as values (removing formulas) and the pull then worked.

Steps to reproduce:

• Create an Excel file where some rows use formulas
• Try and read in the file in GH using BHoM pull (and Excel adapter)

Expected behaviour:

• The adapter reads in the values which are as a result of the functions, not producing an error.

[HugoVanLooveren]

I guess related to this issue is the fact that importing Excel content results in Goo types for numbers.

In BHoM version 7.0.1.1 it works:

To reproduce you need an Excel with a column filled with numbers. You can also use the one attached:
Book2.xlsx
(Could not attach a .gh file, so that should be made by yourself)