openpyxl库教程：精简使用上手快

一、安装

pip install openpyxl

二、读

from openpyxl import load_workbook
work = load_workbook('500部豆瓣电影.xlsx')
sheet = work.active
# 读取 A 整列
for cell in sheet['A']:
	print(cell.value)
# 读取第一行
for cell in sheet[1]:
	print(cell.value)
# 读取所有行
for row in sheet:
    print([cell.value for cell in row])

三、写

from openpyxl import Workbook
bork = Workbook()
sheet = bork.active
sheet.append(['内容1'，'内容2'，'内容3'])
bork.save('文件.xlsx')

三、读取第二个表

from openpyxl import load_workbook
work = load_workbook('500部豆瓣电影.xlsx')
sheet_names = work.sheetnames
sheet = work[sheet_names[1]]
for row in sheet:
	line = [cell.value for cell in row]
	print(line)