python 基础学习系列（十）--excel处理

Python处理表格

方法一： import openpyxl as xl from openpyxl.chart import BarChart,Reference wb=xl.load_workbook('transactions.xlsx') sheet=wb['Sheet1'] #取得单元元素 #cell=sheet['a1'] #cell=sheet.cell(1,1) #打印元素 #print(cell.value) #print(sheet.max_row)

for row in range(2,sheet.max_row+1): cell=sheet.cell(row,3) collected_price = cell.value * 0.9 collected_price_cell = sheet.cell(row,4) collected_price_cell.value = collected_price

values=Reference(sheet, min_row=2, max_row=sheet.max_row, min_col=4, max_col=4)

chart=BarChart() chart.add_data(values) sheet.add_chart(chart,'e2')

wb.save('transactions2.xlsx')

方法二： import openpyxl as xl from openpyxl.chart import BarChart,Reference

def process_workbook(filename): wb=xl.load_workbook(filename) sheet=wb['Sheet1'] #取得单元元素 #cell=sheet['a1'] #cell=sheet.cell(1,1) #打印元素 #print(cell.value) #print(sheet.max_row)

for row in range(2,sheet.max_row+1):
    cell=sheet.cell(row,3)
    collected_price = cell.value * 0.9
    collected_price_cell = sheet.cell(row,4)
    collected_price_cell.value = collected_price

values=Reference(sheet,
                 min_row=2,
                 max_row=sheet.max_row,
                 min_col=4,
                 max_col=4)

chart=BarChart()
chart.add_data(values)
sheet.add_chart(chart,'e2')

wb.save(filename)

https://blog.csdn.net/shuiyixin/article/details/90370387 发现自己的表格文件无法打开的时候，可以参考这篇博客

运行之前的excel文件

运行之后的excel文件