python读写Excel文件

1、读Excel文件

import xlrd

xlsx = xlrd.open_workbook('C:/7月下旬入库表.xlsx')
table = xlsx.sheet_by_index(0)
print(table.cell_value(1, 2))

2、写Excel文件

import xlwt

new_workbook = xlwt.Workbook()
worksheet = new_workbook.add_sheet('new_test')
worksheet.write(0, 0, 'test')
new_workbook.save('C:/test.xls')

3、复制Excel文件

import xlrd, xlwt

xls = xlrd.open_workbook('C:/7月下旬入库表.xlsx')
new_workbook = xlwt.Workbook()
worksheet = new_workbook.add_sheet('new_test')
table = xls.sheet_by_index(0)
for i in range(0, table.nrows):
    for j in range(0, table.ncols):
        print(table.cell_value(i, j))
        worksheet.write(i, j, table.cell_value(i, j))
new_workbook.save('C:/test.xls')