python对excel文件进行操作

python对Excel文件进行读写、复制、删除等操作

#coding: utf-8import xlrd, shutil, os, xlwtfrom xlutils.copy import copydef 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)