python对excel文件进行操作

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)