- PyPI网站搜索工具包openpyxl。
- 在PyCharm窗口下方选择“terminal”,在终端窗口运行命令 pip install openpyxl
- Python代码将Excel中的price(第C列)涨价1.2后保存到第E列,并用新价格生成一个bar char。
import openpyxl as xl
from openpyxl.chart import Reference, BarChart
wb = xl.load_workbook("commodity.xlsx")
sheet = wb["Sheet 1"]
for row in range(2, sheet.max_row + 1):
cell = sheet.cell(row, 3)
new_price_cell = sheet.cell(row, 5)
new_price_cell.value = float(cell.value) * 1.2
values = Reference(sheet, min_row=2, max_row=sheet.max_row, min_col=5, max_col=5)
chart = BarChart()
chart.add_data(values)
sheet.add_chart(chart, 'a11')
wb.save('result.xlsx')