Apr-27-2020, 05:43 PM
Looks like have to modify a
when in a DataFrame(look like Excel in a NoteBook) then the power is great for all kind of stuff.
When finish with changes
copy
with xlutils,then write to a new document with those changes.from xlutils.copy import copy from xlrd import open_workbook w = copy(open_workbook('example.xls')) w.get_sheet(0).write(0, 0, "foo") w.save('example_1.xls')I use Pandas always for stuff like this
df.read_excel()
,when in a DataFrame(look like Excel in a NoteBook) then the power is great for all kind of stuff.
When finish with changes
df.to_excel()