xlutils_copy_read_modify_save_existing_excel_file.py

1import os
2from xlrd import open_workbook
3from xlutils.copy import copy
4
5# 1. Open an existing workbook using xlrd
6# Note: In a real scenario, replace 'example.xls' with your actual file path
7rb = open_workbook('example.xls')
8
9# 2. Use xlutils.copy to create an xlwt Workbook object from the xlrd Workbook
10wb = copy(rb)
11
12# 3. Get a sheet and write data to it using xlwt syntax
13s = wb.get_sheet(0)
14s.write(0, 0, 'modified data')
15
16# 4. Save the modified workbook
17wb.save('example.xls')