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.