学习Python纪录Day23 - 读取指定储存泛范围的资料

读取指定储存泛范围的资料

• 建立get_rows()函式读取指定范围的资料
• iter_rows()取出此范围的物件

def get_rows(ws, min_row, max_row, min_col, max_col):
	rows_range = ws.iter_rows(max_row = max_row, min_row = min_row,
						  max_col = max_col, min_col = min_col)
	rows = []
	for row in rows_range:
		columns = []
		for column in row:
			columns.append(columns)
		return rows

wb = load_workbook("Top 10 most Streamed.xlsx")
ws = wb['Top 10 most Streamed']
rows = get_rows(ws, 2, 5, 2, 4)
for row in rows:
	printf(row)
wb.close()

建立Excel试算表

• 使用openplyxl建立一份全新的Excel试算表
• title属性指定工作表名称

from openpyxl import Workbook
wb = Workbook()
ws = wb.active
ws.title = "成绩表1"

指定储存格资料

ws["A1"] = "座号"
ws["B1"] = "姓名"
ws["C1"] = "国文"
ws["D1"] = "数学"

ws.append([1, Chang, 80, 95])
ws.append([2, Chen, 90, 85])

wb.save("Excelt成绩单.xlsx")
wb.close()

title属性指定工作表名称