EXCEL+PYTHON学习2:
1) 设置单元格的值:
import openpyxl wb = openpyxl.Workbook() # 建立空白的工作簿 ws = wb.active # 取得目前工作表 ws.cell(row=2, column=1, value='Apple') ws.cell(row=3, column=1, value='Orange') ws.cell(row=2, column=2, value=200) ws.cell(row=3, column=2, value=150) wb.save('out3_3.xlsx') # 将工作簿储存 2) 取得单元格的值:
wb = openpyxl.load_workbook(fn) ws = wb.active print("单元格B2 = ", ws.cell(row=2, column=2).value) print("单元格B3 = ", ws.cell(row=3, column=2).value) print("单元格B4 = ", ws.cell(row=4, column=2).value) print("单元格C3 = ", ws.cell(row=3, column=3).value) print("单元3格C4 = ", ws.cell(row=4, column=3).value) 3)如果单元格有公式的话,取得的是公式,如果要取得值,则: 要用data_only=True
wb = openpyxl.load_workbook(fn, data_only=True) 4) 取得单元格位置信息
n = 'data3_10.xlsx' wb = openpyxl.load_workbook(fn) ws = wb.active print(f"A1 = {ws['A1'].value}") print(f"A1 = {ws['A1'].column}, {ws['A1'].row}, {ws['A1'].coordinate}") coordinate,返回位置,比如A1,A2等。 5) 取得工作表使用的列数和行数
wb = openpyxl.load_workbook(fn) ws = wb.active print(f"工作表列数 = {ws.max_column}") print(f"工作表行数 = {ws.max_row}")