openpyxl

openpyxl库的使用，这个处理xlsx还是挺有用的

ref:传送门

 from openpyxl import Workbook
 from openpyxl import load_workbook
 from openpyxl.cell import get_column_letter #---------------读取表内容
 wb=load_workbook(filename=r'1.xlsx');   #打开一个xlsx文件
 sheetnames = wb.get_sheet_names()       # get a list of all the sheet names in the workbook by calling the get_sheet_names() method
 ws = wb.get_sheet_by_name(sheetnames[0])    #获取第一个表
 for i in range(1,3):                    #获取表内容  或者ws['B2'].value
     for j in range(1,4):
         print ws.cell(row=i,column=j).value,
     print
 print ws.max_column,ws.max_row;     #获取行，列数
 print get_column_letter(6);
 for i in ws['A1':'C2']: #获取每一行
     #print i
     for j in i:
         print j.coordinate,j.value #-------------创建表写入内容
 a=Workbook()
 a.create_sheet(index=0,title='')  #表名
 sheet=a.get_sheet_by_name('');
 for i in range(1,5):
     for j in range(1,2):
         sheet.cell(row=i,column=j).value=''
 '''
 for i in sheet['A1':'C5']:
     for j in i:
         j.value='6';
 '''
 a.save('6.xlsx');