使用Python读写Excel文件（2）

516551411

以下几个函数有更新了

DeprecationWarning: Call to deprecated function get_sheet_names (Use wb.sheetnames).

DeprecationWarning: Call to deprecated function get_sheet_by_name (Use wb[sheetname]).

DeprecationWarning: Call to deprecated function remove_sheet (Use wb.remove(worksheet) or del wb[sheetname]).

张树袋

1

lslslsls12

1

fytfytf

6666

penut'

1

红蓝cp

...

tech_2013

答案回复可见

爱笑的皮卡媛

嘿嘿

反清复明君

ooo

616476055

答案

zcrui9911

看看

lwhhlb

import openpyxl as oxl

wb = oxl.load_workbook("豆瓣top250电影.xlsx")

sheet_names = wb.sheetnames
ws = wb[sheet_names[0]]
nws = wb.copy_worksheet(ws)

for each_row in nws.rows:
    if each_row[0].value == '阿甘正传':
        each_row[1].value = '9.8'

    if each_row[0].value == '这个杀手不太冷':
        each_row[1].value = '9.6'

    if each_row[0].value == '肖申克的救赎':
        each_row[1].value = '9.7'

wb.save("豆瓣top250电影.xlsx")

KevinHu

import openpyxl

wb = openpyxl.load_workbook("豆瓣TOP250电影.xlsx")
ws = wb.get_sheet_by_name("Sheet")

for goal, value in [("阿甘正传", 9.8), ("这个杀手不太冷", 9.6), ("肖申克的救赎", 9.7)]:
    name = ws['A1']
    while name.value != goal:
        name = name.offset(1, 0)
    score = name.offset(0, 1)
    score.value = value

wb.save("豆瓣TOP250电影（改）.xlsx")

lznanjing

123456

ylzhangxinjiang

新手报到。

fishc098

朕想知道

则微

学习学习

杨老师很厉害

做完了

三叶

好好学习，就是贵了点