import xlwt;
import xlrd;
from xlutils.copy import copy;
#styleBoldRed = xlwt.easyxf('font: color-index red, bold on');
#headerStyle = styleBoldRed;
#wb = xlwt.Workbook();
#ws = wb.add_sheet('sheetName');
#ws.write(0, 0, 'Col1', headerStyle);
#ws.write(0, 1, 'Col2', headerStyle);
#ws.write(0, 2, 'Col3', headerStyle);
#wb.save('fileName.xls');
#open existed xls file
oldWb = xlrd.open_workbook( 'fileName.xls' , formatting_info = True );
oldWbS = oldWb.sheet_by_index( 0 )
newWb = copy(oldWb);
newWs = newWb.get_sheet( 0 );
inserRowNo = 1
newWs.write(inserRowNo, 0 , 'value1' );
newWs.write(inserRowNo, 1 , 'value2' );
newWs.write(inserRowNo, 2 , 'value3' );
for rowIndex in range (inserRowNo, oldWbS.nrows):
for colIndex in range (oldWbS.ncols):
newWs.write(rowIndex + 1 , colIndex, oldWbS.cell(rowIndex, colIndex).value);
newWb.save( 'fileName.xls' );
print 'save with same name ok' ;
|