python读取excel

工具准备

excel读取

import xlrd
xlsx = xlrd.open_workbook(filename)
table = xlsx.sheet_by_index(0)
table = xlsx.sheet_by_name(sheetname)
table.cell_value(1,2)
table.cell(1,2).value
table.row(1)[2].value

excel 写入

import xlwt
new_workbook = xlwt.Workbook()
work_sheet = new_workbook.add_sheet('new_sheet')
work_sheet.write(0,0,'This is a test')
new_workbook.save(filename)

格式写入

from xlutils.copy import copy
import xlrd
import xlwt

tem_excel = xlrd.open_workbook(filename,formating_info = Ture)
tem_sheet = tem_excel.sheet_by_index(0)

new_excel = copy(tem_excel)
new_sheet = new_excel.get_sheet(0)