1.csv需要转化为.xls:
from pandas.io.excel import ExcelWriter
from xlsxwriter.workbook import Workbook
#read csv
fileItem_real_total_final=‘c:’+’/bin_summary_file_merged_total_final.csv’
df1=pd.read_csv(fileItem_real_total_final)
csv_files = [fileItem_real_total_final]
#csv change to excel format
with ExcelWriter(monitor2) as ew:
for csv_file in csv_files:
pd.read_csv(csv_file).to_excel(ew, sheet_name =‘monitor’, index = False)
workbook = Workbook(monitor2)
import xlwt
import xlrd
from xlutils import copy
file_name=monitor2
#单元格上色
#单元格上色
def color_execl(file_name):
styleBlueBkg = xlwt.easyxf(‘pattern: pattern solid, fore_colour red;’) # 红色
rb = xlrd.open_workbook(file_name) #打开t.xls文件
ro = rb.sheets()[0] #读取表单0
wb = copy.copy(rb) #利用xlutils.copy下的copy函数复制
ws = wb.get_sheet(0) #获取表单0
col = 1