|
import openpyxl
workbook = openpyxl.load_workbook("test.xlsx")
# 输出工作簿中所有表单名字
print(workbook.sheetnames)
# 变量所有表单并输出其名字
for sheet in workbook:
print(sheet.title)
# 创建表单
newSheet = workbook.create_sheet("newSheetName")
# 获取表单对象
sheet3 = workbook.get_sheet_by_name("Sheet3")
sheet4 = workbook["newSheetName"]
# 获取当前活跃的表单
worksheet = workbook.active
# 获取单元格对象
selectcell = worksheet["A1"]
selectcell = worksheet.cell(row=1, column=2) # 行列号从1开始
# 获取单元格行列和值
print(selectcell.row, selectcell.column, selectcell.value)
# 获取单元格坐标，如"A1"
print(selectcell.coordinate)
# 获取列对象
selectcol = worksheet["C"]
# 获取列中某一单元格
selectcell = selectcol["2"]
# 获取连续多列组成的对象
selectcols = worksheet["B:C"]
# 获取行对象
selectrow = worksheet["2"]
# 获取行中某一单元格
selectcell = selectcol["C"]
# 获取连续多列组成的对象
selectcols = worksheet["1:4"]
# 获取所有行组成的对象
allrow = worksheet.rows
# 获取所有列组成的对象
allcol = worksheet.cols
# 获取一定范围内的单元格组成的对象
cell_range = worksheet["A1:C3"]
for row_range in cell_range: # 先行再列
for cell in row_range:
print(cell.value)
#
from openpyxl.utils import get_column_letter, column_index_from_string
print(get_column_letter(2))) # 2 => B
print(column_index_from_string("C")) # C => 3
|
