How to read and write data in Microsoft excel 2010 in python

Question

Steps what I have done

1.Reading input data from xlsx file

2.calculated week number and total hours done by each department

Need to do:

1.Reading particular row column from another existing xlsx sheet

2.writing total hours for each department in existing xlsx sheet

I am using xlutils but format of xlsx file has been corrupted,which library i should use for this?

The documentation makes it clear that xlutils cannot edit XLSX files. — Charlie Clark, Sep 14 '15 at 08:54

score 1 · Accepted Answer · answered Sep 14 '15 at 08:51

1

According to http://www.python-excel.org/ , the best library to read/write Excel 2010 files is openpyxl.

answered Sep 14 '15 at 08:51

Eric Levieil

1 Answers1