表格汇总
import xlwt
import xlrd
from xlwt import Workbook
import xlwings as xw
from openpyxl import load_workbook
import openpyxl.styles as sty
def new_sheet():
book = Workbook(encoding='utf-8')
sheet1 = book.add_sheet('Sheet 1')
book.save(path='新建表格路径')
def get_data():
data_list = []
for x in range(1, 6):
table = xlrd.open_workbook(path='需要填充数据的表格路径')
sheet = table.sheets()[0]
rows = sheet.nrows
for y in range(rows):
data_list.append(sheet.row_values(y))
return data_list
def write_data():
a = 1
for x in get_data():
wb = xw.Book(path='汇总的表路径')
sht = wb.sheets[0]
sht.range('A{0}'.format(a)).options(index=False).value = x
wb.save()
a += 1
excel 表格填充颜色的功能块
workbook = Workbook(encoding='utf-8')
worksheet = workbook.add_sheet('Sheet1')
pattern = xlwt.Pattern()
pattern.pattern = xlwt.Pattern.SOLID_PATTERN
pattern.pattern_fore_colour = 5
style = xlwt.XFStyle()
style.pattern = pattern
又一个发帖加入撰稿人队伍的,一看 python 功底就不错,遇到自行解决的问题,多发共享帖子,也多来看这边文档提意见