Openpyxl is a Python library for reading and writing Excel 2010 xlsx/xlsm/xltx/xltm files. It was born from lack of existing library to read/write natively from Python the Office Open XML format.
openpyxl
openpyxl
Openpyxl is a Python library for reading and writing Excel 2010 xlsx/xlsm/xltx/xltm files. It was born from lack of existing library to read/write natively from Python the Office Open XML format.
10.0/10
(Expert Score)
★★★★★
Product is rated as #2 in category Component Libraries Software
Customer Reviews
openpyxl Reviews
Thirumal R.
Advanced user of openpyxl★★★★★
What do you like best?
Easy to use
Easy to create multiple sheets
There is also a provision to write dictionary/list data
Easy to perform read/write operations between multiple excel files
It's an open source library
You can perform search and sort operations on data
What do you dislike?
Losing merged cells border while editing Excel file
Sometimes can't open newly created excel file
Memory usage is high by comparing with other libraries
Recommendations to others considering the product:
It's an open source library
Easy to work with multiple excel sheets.
it's very fast in reading operations and give better performance
You can perform search and sort operations on data
What problems are you solving with the product? What benefits have you realized?
While working with boring stuff like copying data between multiple files, we can automate it and reading data is faster by applying search functionality
