Python——office编程

 import xlrd

 path=input("输入路径：")

 workbook=xlrd.open_workbook(path)#打开该Excel

 sheet=workbook.sheet_by_index(1)#选择表单

 for row in range(sheet.nrows):#遍历行，row行

     print()#换行

     for col in range(sheet.ncols):

         print("%7s"%sheet.row(row)[col].value,'\t',end='')

 import xlwt

 # 创建一个workbook 设置编码

 workbook = xlwt.Workbook(encoding = 'utf-8')

 # 创建一个worksheet

 worksheet = workbook.add_sheet('My Worksheet')

 # 写入excel

 # 参数对应 行, 列, 值

 worksheet.write(1,0, label = 'this is test')

 # 保存

 workbook.save('Excel_test.xls')