python对Excel文件进行读写、复制、删除等操作
#coding: utf-8
import xlrd, shutil, os, xlwt
from xlutils.copy import copy
def readExcel(path, index):
data = xlrd.open_workbook(path) # 读取excel内容
sheet = data.sheet_by_index(index) # 根据下标获取表格内容
rows = sheet.nrows # 获取表格所有行
for row in range(rows):
if row > 3:
value = sheet.row_values(row) # 根据下标获取相应行的内容
if value[10]:
equ_name = value[10]
troop_name = value[2]
shutil.copy(u'E:b.xlsx', u'E:' + u'c.xlsx') # 复制excel文件至指定目录
filename = u'E:' + u'b.xlsx' # 往已存在的excel中写入内容
rb = xlrd.open_workbook(filename)
wb = copy(rb)
st = wb.get_sheet(0)
st.write(3,0,troop_name)
st.write(3,1,equ_name)
os.remove(filename)
filename = u'E:d.xls'
wb.save(filename)
if __name__ == '__main__':
readExcel(u'E:a.xlsx', 0)