Reading formula values from Excel in Cadwork Python without Pandas

[mankatmalte-dev]

Hi all,

I’m trying to read formula-evaluated values from an Excel sheet (.xlsx) in the Cadwork Python API. I initially considered using Pandas, but importing it (and NumPy) inside Cadwork seems a bit tricky.

I need to read the calculated content of formulas, which is why saving the sheet as CSV is not ideal.

Has anyone faced a similar issue and found a simple way to read Excel formulas without installing Pandas or other external modules, so it would work reliably for everyone using the plugin?

Thanks in advance for any advice!

[Antoine-S-C]

Hi,
I use a different module: openpyexcel. If you don't want to install the module, you can copy all its files (about 4 MB) into your .py folder.
Openpyexcel allows you to read, write, and modify the appearance of an Excel file.

[Brunner246]

#326

#259

#66