access excel sheet programatically

• pycel

  3 551 0.0 Python

  A library for compiling excel spreadsheets to python code & visualizing them as a graph

Kind of. There are a few libraries that attempt to give full Excel formula functionality in Python, but they are not complete. That is to say, they don't work on all formulae, and certain newer Excel feature (like array formulae) are unsupported. These are: pycel, koala, xlcalculator.

• koala

  1 139 0.0 Python

  Transpose your Excel calculations into python for better performances and scaling. (by vallettea)

Kind of. There are a few libraries that attempt to give full Excel formula functionality in Python, but they are not complete. That is to say, they don't work on all formulae, and certain newer Excel feature (like array formulae) are unsupported. These are: pycel, koala, xlcalculator.

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• xlcalculator

  3 105 4.4 Python

  xlcalculator converts MS Excel formulas to Python and evaluates them.

Kind of. There are a few libraries that attempt to give full Excel formula functionality in Python, but they are not complete. That is to say, they don't work on all formulae, and certain newer Excel feature (like array formulae) are unsupported. These are: pycel, koala, xlcalculator.

• xlwings

  25 2,834 8.5 Python

  xlwings is a Python library that makes it easy to call Python from Excel and vice versa. It works with Excel on Windows and macOS as well as with Google Sheets and Excel on the web.

  

Another approach is to use Python to "drive" an Excel instance, in much the same way as VBA. You can do this with pywin32 calls, or with the dedicated xlwings library.

Suggest a related project