openpyxl

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');