说明:
1、通过openpyxl模块统计excel表格数据
2、通过xlrd模块统计excel表格数据
3、插入table表格数据
#! /usr/bin/python3
# -*- coding: utf-8 -*-
from openpyxl import Workbook
from openpyxl import load_workbook
from openpyxl.worksheet.table import Table, TableStyleInfo
from collections import Counter
from openpyxl.chart import BarChart, Reference, Series
from xlrd import open_workbook
class ReadExcel():
# xlrd读取excel表格
# def read_data(self, file_name):
# wb = open_workbook(file_name)
# sheet = wb.sheets()[0]
# row = sheet.nrows
# col = sheet.ncols
# print(row, col)
# data_list = []
# # 读取标题外的所有数据
# for num in range(1, row):
# item = sheet.row_values(num)
# data_list.append(item)
#
# return data_list
# openpyxl读取excel表格
def read_data(self):
# 读取excel表格中的默认表
sheet = wb.worksheets[0]
# 获取到所有行的数
rows = list(sheet.rows)
# 获取标题
title_list = []
for title in rows[0]:
title = title.value
title_list.append(title)
# 除了标题外,获取所有数据
data_list = []</