What is the best library in python to deal with excel files

0 votes
I have big excel with lot of sheets and formulas interlinked within the sheets. I need to populate input in one sheet using the code and recalculate all the formulas to get my output from another sheet.

I am able to do this with apache POI using Java but it is too slow in formula recalculation. Looking for libraries in Python to do the same.
Apr 4 in Database by gaurav
• 13,460 points
89 views

1 answer to this question.

0 votes
XlsxWriter and Xlwings are the best, in my experience. Both of them run quickly and rapidly, and they offer good Python and Excel compatibility.

There are two versions of Xlwings: Free and Pro (paid version). The free version has all of the features and can do practically anything with an Excel file. You can obtain extra capability and support with the subscription version, which developers (not average users) don't require most of the time.

XlsxWriter, on the other hand, is a fantastic option, and its user base is rapidly expanding. It includes everything you'll need to deal with an excel file.

Both of them are simple to set up using pip and conda.

Other libraries, such as xlrd and xlwt, were built to handle old version (.xls) files in the past. They don't even come close to the other two libraries I mentioned.

OpenPyXl is also a good library that can take care of most of your needs. More funding is required for the library to expand. It is not yet mature, in my opinion.

Reading and writing data to an Excel file is also possible with the Pandas and pyexcel libraries. Pandas is my preferred library since it is a mature and fast library that can handle large amounts of data. Working with pyexcel is more difficult because it is a wrapper API that is not as capable as Pandas.
answered Apr 4 by Edureka
• 13,640 points

Related Questions In Database

0 votes
1 answer

What is the best way to fetch data from table?

Hey Shraddha, I understand your doubts about fetching ...READ MORE

answered May 25, 2019 in Database by sampriti
• 1,120 points
971 views
0 votes
1 answer

I have to build a school website How can i connect databases to the instance (ec2) and what is the best AMI for my webserver INAWS ???

Hi@Trinu, I don't think your database is depends ...READ MORE

answered May 4, 2020 in Database by MD
• 95,360 points
289 views
0 votes
1 answer

What is the Excel formula to countif text partially makes up a cell?

With Formulas, Countif Partial String/Substring Match We can ...READ MORE

answered Mar 30 in Database by gaurav
• 13,460 points
36 views
0 votes
1 answer

How to deal with "Microsoft Excel is waiting for another application to complete an OLE action"

The first step in troubleshooting is to ...READ MORE

answered Apr 6 in Database by gaurav
• 13,460 points
98 views
0 votes
2 answers

What are the ways to get the count of records in a table

With the help of the SQL count ...READ MORE

answered Aug 20, 2020 in Database by Okugbe
• 280 points
1,974 views
0 votes
1 answer

What is the SQL query to get the third highest salary of an employee from employee_table

You can try out something like this: SELECT ...READ MORE

answered Sep 27, 2018 in Database by Sahiti
• 6,380 points
7,228 views
0 votes
1 answer

What is the ORDER BY statement in MySQL?

This statement is used to sort the ...READ MORE

answered Nov 23, 2018 in Database by Sahiti
• 6,380 points
223 views
0 votes
1 answer

What is the syntax of USE statement in MySQL?

The USE statement is used to mention ...READ MORE

answered Nov 27, 2018 in Database by Sahiti
• 6,380 points
288 views
0 votes
1 answer

How to transform multiple tables in one excel sheet to one table with Power BI?

If my prediction is correct- You have a ...READ MORE

answered Apr 4 in Database by Edureka
• 13,640 points
88 views
0 votes
1 answer

How to view the XML form of an Excel file?

Excel is a spreadsheet programme. Click File->Open in ...READ MORE

answered Mar 25 in Database by Edureka
• 13,640 points
104 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP