working xlsx/xls libraries for python[SOLVED] | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 2

working xlsx/xls libraries for python[SOLVED]

which libraries do you know and advice to use?

26th Aug 2020, 10:50 AM
Shadoff
Shadoff - avatar
4 Answers
+ 2
I can recommend openpyxl, but you can also try some other ones, if you need: https://www.python-excel.org/
29th Aug 2020, 4:13 AM
Kuba Siekierzyński
Kuba Siekierzyński - avatar
+ 2
Avalon So what you need to do, only read the file or edit it with Python, too?
29th Aug 2020, 11:55 AM
Kuba Siekierzyński
Kuba Siekierzyński - avatar
+ 1
Kuba Siekierzyński , openpyxl cant work with older version xls files
29th Aug 2020, 7:32 AM
Shadoff
Shadoff - avatar
+ 1
Never mind. I have already find proper library. For xls files I used xlrd lib. the task was to collect data from thousands of xls files with the same column. And then add all data row by row to the sqlite db
29th Aug 2020, 6:14 PM
Shadoff
Shadoff - avatar