使用xlutils先拷贝再写入。(保存样式)
import xlwt;
import xlrd;
#import xlutils;
from xlutils.copy import copy;
styleBoldRed =xlwt.easyxf('font: color-index red, bold on');
headerStyle =styleBoldRed;
wb =xlwt.Workbook();
ws =wb.add_sheet(gConst['xls']['sheetName']);
ws.write(0, 0, "Header", headerStyle);
ws.write(0, 1, "CatalogNumber", headerStyle);
ws.write(0, 2, "PartNumber", headerStyle);
wb.save(gConst['xls']['fileName']);
#open existed xls file
#newWb = xlutils.copy(gConst['xls']['fileName']);
#newWb = copy(gConst['xls']['fileName']);
oldWb =xlrd.open_workbook(gConst['xls']['fileName'], formatting_info=True);
printoldWb; #
newWb =copy(oldWb);
printnewWb; #
newWs =newWb.get_sheet(0);
newWs.write(1, 0, "value1");
newWs.write(1, 1, "value2");
newWs.write(1, 2, "value3");
print"write new values ok";
newWb.save(gConst['xls']['fileName']);
print"save with same name ok";
