I want to read a text file, write into an windows .xls file ie., create a .xls file and later do some modifications to the created .xls file. I have google'd as to what are all the available packages:
Win32 Com client
--> xlrd (Only for Reading from xls files I guess)
|
--> xlwt (only for writing into xls files)
PyExcelerator
What is the best module to perform these actions? Any suggestions?
xlwt works great.
If you want to create .xlsx
files (the new format used in Office 2007 and 2010), there is openpyxl.
I would recommend a native python library (xlwt or openpyxl) over using PyWin32 COM automation to drive Excel.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With