python数据分析&办公自动化实战(六)：excel条件格式、单元格格式、数字格式

#简介#
本篇是使用openpyxl库的一点经验总结，涉及到以下功能：操作excel、设置边框背景颜色居中等格式、设置数字格式（小数百分数）、百分比条件格式、插入行列等，依然是代码+注释+总结。
任务目标：批量调整excel格式，并设置条件格式

#代码展示#
#仅展示思路，代码做了简化

import pandas as pd
import openpyxl
from openpyxl import Workbook,load_workbook
from openpyxl.utils.dataframe import dataframe_to_rows
from openpyxl.styles import PatternFill,Font,Color,PatternFill,Alignment,numbers,Border,Side
from openpyxl.formatting.rule import ColorScaleRule, CellIsRule, FormulaRule
import os,sys
import numpy as np


def walk(path):
    if not os.path.exists(path):
        return -1
    for root,dirs,names in os.walk(path):
        for filename in names:
            if os.path.splitext(filename)[1] == '.xlsx':
                doc = os.path.join(root,filename)
                print(doc)
                csvlist.append(doc)

#确定当前所在的文件夹路径
csvlist = []
cur_path = os.getcwd()
walk(cur_path)

def my_border(t_border, b_border, l_border, r_border):
    border = Border(top=Side(border_style=t_border, color="000000"),
                    bottom=Side(border_style=b_border, color="000000"),
                    left=Side(border_style=l_border, color="000000"),
                    right=Side(border_style=r_border, color="000000"))
    return border

def format_border(s_column, s_index, e_column , e_index):
    for row in tuple(sheet[s_column + str(s_index):e_column + str(e_index)]):
        for cell in row:
            cell