how do i insert few row in an existing excel file using python? the excel file maybe be of any excel version. On windows that could have been possible by using win32com.client...but i need to make the changes in the linux environment. how can i do it?
2 Answers
you can use pyExcelerator. the package comes with example demos to write excel files
2 Comments
TheSteve0
xlwt is a fork of pyExcelerator so the demos are probably the same. Based on this groups.google.com/group/python-excel/browse_thread/thread/… I would say that pyExcelerator is no longer maintained
John Machin
@ghostdog74: pyExcelerator has a bad case of the Norwegian Blue Parrot syndrome. xlwt has extra functionality, better speed, uses less memory and has a tutorial ... see python-excel.org
I'm looking into this myself and found https://bitbucket.org/ericgazoni/openpyxl/wiki/Home . It is a new library that allows editing xlsx files.