xlutils_copy_read_modify_save_existing_excel_xls.py

1import xlrd
2from xlutils.copy import copy
3
4# 1. Open an existing workbook using xlrd
5rb = xlrd.open_workbook('my_file.xls')
6
7# 2. Create a writable copy of the workbook using xlutils
8wb = copy(rb)
9
10# 3. Access a specific sheet and write data
11# (Note: xlutils provides access to xlwt-style sheet objects)
12ws = wb.get_sheet(0)
13ws.write(0, 0, 'changed!')
14
15# 4. Save the modified workbook using xlwt
16wb.save('my_file.xls')