openpyxl 学习笔记2

 

 

from openpyxl import Workbook
from openpyxl.compat import  range
from openpyxl.utils import get_column_letter

wb = Workbook()
dest_filename = 'empty_book.xlsx'
ws1 = wb.active
ws1.title = 'range names'

for row in range(1,40):
    ws1.append(range(600))

ws2 = wb.create_sheet(title='Pi')
ws2['F5'] = 3.24

ws3 = wb.create_sheet(title='Data')
for row in range(10,20):
    for col in range(27,54):
        _ =ws3.cell(column=col, row=row, value="{0}".format(get_column_letter(col)))

print(ws3['AA10'].value)
wb.save(filename=dest_filename)




from openpyxl import load_workbook
wb = load_workbook(filename = './白宝乡贫困劳动力核实（霞头）.xlsx')
sheet_ranges = wb['range names']
print(sheet_ranges['D18'].value)

 

 

 

 

3

 

参考： https://openpyxl.readthedocs.io/en/stable/