安装xlrd、xlwt、xlutils
#coding=utf-8
import xlrd
import xlwt;
import sys, getopt
from xlutils.copy import copy;
class Excel:
def __init__(self,fileName):
self.bookold = xlrd.open_workbook(fileName)
self.book=copy(self.bookold)
def insert_merchant_number(self):
sheet=self.bookold.sheet_by_index(0)
nrows = sheet.nrows
ncols = sheet.ncols
sheetnew=self.book.get_sheet(0);
cnt=0
flag=0
merchant_number=""
for r in range(0,nrows-1):
cellvalue=sheet.cell_value(r,0)
if cellvalue==u"特约单位编号/部门编号:":
merchant_number=sheet.cell_value(r,1)
merchant_number=int(merchant_number)
merchant_number=str(merchant_number)
print u"商户号"+merchant_number
flag=1
if flag==1 and cellvalue!=u"特约单位编号/部门编号:" and cellvalue!=u"特约单位合计":
mer=sheet.cell_value(r,0)
mer=int(mer)
print "value "+str(mer)
#mer=str(mer)
mer=str(merchant_number)
info=u"写入数据: "
print info+mer
sheetnew.write(r,0,mer);
if cellvalue==u"特约单位合计":
flag=0
def save_excle_file(self,fileName):
self.book.save(fileName)
def main():
opts, args = getopt.getopt(sys.argv[1:], "hi:o:",["ifile=","ofile="])
input_file=""
output_file=""
mer=""
for op, value in opts:
if op == "-i":
input_file = value
elif op == "-o":
output_file = value
elif op == "-h":
sys.exit()
excel=Excel(input_file)
excel.insert_merchant_number()
excel.save_excle_file(output_file)
if __name__=="__main__":
main()