Python和Excel结合的一些应用

数据展现

import xlrd
import pandas as pd
import numpy as np

url ="C:\\Users\\FCX\\Desktop\\君子供货台账 (2).xlsx"

data = xlrd.open_workbook(url)

sheets = ['营收指标完成情况汇总', '君子合作业务汇总表', '共管账户流水(680)', '共管账户流水(946)', 'DL20190801', 'DL20190802', 'GH20190805', 'DL20190803', 'GH20190806', 'DL20190901', 'GH20190901', 'DL20190902', 'GH20190902', '20191001年底结算完毕', '20191002', '20191101', '20191102', '2019', '2020', '发票记录', 'WpsReserved_CellImgList']

# table = data.sheet_by_name("DL20190802")

data = pd.read_excel(url, sheet_name = "DL20190802", header = 0, skiprows = [1,2], skip_footer = 50)
#参数详见  https://blog.csdn.net/brucewong0516/article/details/79096633
#skiprows省略前两行--  skiprows= 2,可以数组，30,索设第一列引列—— index_col=0

#da