Python pycharm learning code text record（6）

Python pycharm learning code text record （6）
文章编号：Python学【2020】006号
日期：2020-02-17

---

文章为日常学习记录，以备温习使用，同时作为像我一样的新人学习使用，内容属于学习记录，版权归视频学习提供方。以每天追无聊小说的心态，每天坚持学习码代码。

---

Project1: Automation with Python

import openpyxl as xl
wb = xl.load_workbook('transactions.xlsx')
sheet = wb['Sheet1']
cell = sheet['a1']
cell = sheet.cell(row=1,column=1)
for row_number in range(2,sheet.max_row + 1):
    cell = sheet.cell(row=row_number,column=3)
    corrected_price = cell.value*0.9
    corrected_price_cell = sheet.cell(row=row_number,column=4)
    corrected_price_cell.value = corrected_price
wb.save('transactions2.xlsx')

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(row=1,column=1)
for row_number in range(2,sheet.max_row + 1):
cell = sheet.cell(row=row_number,column=3)
corrected_price = cell.value*0.9
corrected_price_cell = sheet.cell(row=row_number,column=4)
corrected_price_cell.value = corrected_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’)

---

代码块整体后移：
选中要整体移动的代码块，
1、代码块后退
选中后按“Tab"键
2、代码块前进
选中后按”Shift+Tab"键

import openpyxl as xl
from openpyxl.chart import  BarChart,Reference


def process_workbook(filename):
    wb = xl.load_workbook(filename)
    sheet = wb['Sheet1']

    for row_number in range(2,sheet.max_row + 1):
        cell = sheet.cell(row=row_number,column=3)
        corrected_price = cell.value*0.9
        corrected_price_cell = sheet.cell(row=row_number,column=4)
        corrected_price_cell.value = corrected_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)