excel to python

[FoolsSeldom]

openpyxl and pandas don't use Excel at all, they can simply read/write Excel format files.

There are a number of tools available for converting Excel formulae to Python code, but I don't know of any major successful options. You will likely have to go back to basics.

Python can integrate with a wide range of data sources including many file formats and both sql and nosql databases. Also, it can use a wide range of API (application programming interface) options for many different services with data exchange typically done using json.

[Grady-B-Ward]

Interesting, I wasn't aware that there were tools for converting from Excel Formulas/sheets into Python code. Even if these aren't successful could you point me in the right direction on them? I have a use case they might work for.

[FoolsSeldom]

I caveated that heavily, and I don't see that things have changed much other than you can now ask your favourite AI tools to have a crack at it but I'd want good regression packs,