上海网站建设宣传网络营销的策略

我用python打开一个现有的excel文件并进行格式化，保存并关闭文件。我的代码在文件大小很小，但当excel大小很大时（大约。40MB）我得到串行化I/O错误，我确定这是由于内存问题或我的代码。请帮忙。在

系统配置：

内存-8 GB

32位操作

Windows 7系统

代码：import numpy as np

from openpyxl import load_workbook

from openpyxl.styles import colors, Font

dest_loc='/Users/abdulr06/Documents/Python Scripts/'

np.seterr(divide='ignore', invalid='ignore')

SRC='TSYS'

YM1='201707'

dest_file=dest_loc+SRC+'_'+''+YM1+'.xlsx'

sheetname = [SRC+''+' GL-Recon']

#Following code is common for rest of the sourc systems

wb=load_workbook(dest_file)

fmtB=Font(color=colors.BLUE)

fmtR=Font(color=colors.RED)

for i in range(len(sheetname)):

sheet1=wb.get_sheet_by_name(sheetname[i])

print(sheetname[i])

last_record=sheet1.max_row+1

for m in range(2,last_record):

if -30 <= sheet1.cell(row=m,column=5).value <=30:

ft=sheet1.cell(row=m,column=5)

ft.font=fmtB

ft.number_format = '_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)'

ft1=sheet1.cell(row=m,column=6)

ft1.number_format = '0.00%'

else:

ft=sheet1.cell(row=m,column=5)

ft.font=fmtR

ft.number_format = '_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)'

ft1=sheet1.cell(row=m,column=6)

ft1.number_format = '0.00%'

wb.save(filename=dest_file)

例外情况：

^{pr2}$