1. xlrd 读EXCEL
import xlrd
xlsx = xlrd.open_workbook('d:/表格1.xlsx')
table = xlsx.sheet_by_index(0)
# 通过sheet名查找:xlsx.sheet_by_name("sheet0")
# 通过索引查找:xlsx.sheet_by_index(3)
print(table.cell_value(0, 0))
# table.cell_value(1, 2)
# print(table.cell(1, 2).value)
# print(table.row(1)[2].value)
for i in range(0, xlsx.nsheets):
table = xlsx.sheet_by_index(i)
print(table.cell_value(0, 0))
# 获取所有sheet名字:xlsx.sheet_names()
# 获取sheet数量:xlsx.nsheets
for i in xlsx.sheet_names():
table = xlsx.sheet_by_name(i)
print(table.cell_value(3, 3))
2. xlwt
import xlrd,xlwt
xlsx = xlrd.open_workbook('d:/表格1.xlsx')
new_workbook = xlwt.Workbook()
worksheet = new_workbook.add_sheet('new_test')
table = xlsx.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('d:/test.xls')
3.xlsxwriter
import xlrd,xlsxwriter
xlsx = xlrd.open_workbook('d:/表格1.xlsx')
new_workbook = xlsxwriter.Workbook('d:/test.xlsx')
worksheet = new_workbook.add_worksheet()
table = xlsx.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.close()