会python真的可以为所欲为0(回)
407天前
这里还有人吗1(回)
592天前这里还有人吗0(回)
592天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
817天前到处都是羊，不想上班0(回)
897天前
鸽子
0(回)
901天前import openpyxl |
workbook = openpyxl.load_workbook('example.xlsx') |
worksheets = workbook.sheetnames |
# 遍历每个工作表并读取数据 |
for sheet_name in worksheets: |
worksheet = workbook[sheet_name] |
for row in worksheet.iter_rows(min_row=1, max_row=worksheet.max_row, |
min_col=1, max_col=worksheet.max_column): |
for cell in row: |
data = cell.value |
print(data) |
