Python操作表格

1. 引入模块

1.1 新建一个py文件

def find_max(numbers):
    maximum = numbers[0]
    for number in numbers:
        if number > maximum:
            maximum = number
    return maximum

1.2 在app.py中引入

from utils import find_max

numbers = [10,6,3,2]
maximum = find_max(numbers)
print(maximum)

1.3 掷骰子

import random


class Dice:
    def roll(self):
        first = random.randint(1,6)
        second = random.randint(1,6)
        return first,second


dice = Dice()
print(dice.roll())

2. 操作表格

2.1 安装openpyxl

pip install openpyxl

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


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

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