1 import xlrd 2 import xlwt 3 4 5 xlsx = xlrd.open_workbook(r'D:pycharmlearningautowork est.xlsx') 6 table = xlsx.sheet_by_index(0) 7 # table = xlsx.sheet_by_name('Sheet1') 8 print(table.cell_value(0, 0)) 9 print(table.cell(0, 0).value) 10 print(table.row(0)[0].value) 11 12 new_workbook = xlwt.Workbook() 13 new_sheet = new_workbook.add_sheet('aaa') 14 new_sheet.write(1, 1, 'hello word') 15 new_workbook.save(r'D:pycharmlearningautowork est2.xls')