python导入excel类库_python 导入openpyxl模块后对excel文件进行读写

from openpyxl import Workbook, load_workbook

def write(file_name, sheet_name, data):

'''

创建excel表格并写数据

:param file_name: 文件名

:param sheet_name: sheet名

:param data: 列表数据

:return:

'''

wb = Workbook()

try:

sheet = wb["kll"]

except KeyError:

sheet = wb.create_sheet(sheet_name, index=0)

##在某一格中写数据

# sheet["A1"]="good"

# 把所有列反转成行

# rows = (zip(*rows))

# 写数据

for row in data:

sheet.append(row)

# 如果此excel是打开状态，则保存不了，报异常PermissionError

wb.save(file_name)

def read(file_name, sheet_name):

'''

读数据

:param file_name: 文件名

:param sheet_name: sheet名

:return:

'''

wb = load_workbook(file_name)

sheet = wb[sheet_name]

for row in sheet.rows:

for cell in row:

print(cell.value, end="\t")

print()

if __name__ == '__main__':

# 添加多行

file_name = r"sophia.xlsx"

sheet_name = "登录"

rows = [

['Number', 'data1', 'data2'],

[2, 40, 30],

[3, 40, 25],

[4, 50, 30],

[5, 30, 10],

[6, 25, 5],

[7, 50, 10],

]

write(file_name, sheet_name, rows)

read(file_name, sheet_name)

进一步说明请参考：https://blog.csdn.net/yetugeng/article/details/84837067