Home python Choosing a Python library for working with Excel

Choosing a Python library for working with Excel

Author

Date

Category

There are several large libraries for Python 3.9.0 to work with Excel files, which at first glance seem to have similar functionality. Please tell me which library is the most convenient and functional at the moment?

Fetching data from Excel 2019 spreadsheet sheets (.xlsx format) and entering data into the table is required. In the future, we plan to work with formulas in tables, as well as work with the .csv format.


Answer 1, authority 100%

For simple work with data (without formulas and graphs), it is enough to use Pandas, which itself under the hood uses either xlrd or openpyxl .

For deeper work with Excel, you can use openpyxl and XlsxWriter are the most advanced and most popular modules for working with Excel.

Programmers, Start Your Engines!

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.

Recent questions