【整理】Python中，添加写入数据到已经存在的Excel的xls文件，即打开excel文件，写入新数据

//写入方法一：

 

import   xlwt;

import   xlrd;

#import xlutils;

from   xlutils.copy  import   copy;

 

#init xls file

#styleBlueBkg= xlwt.easyxf('pattern: pattern solid, fore_colour sky_blue;');

#styleBold   = xlwt.easyxf('font: bold on');

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' ]);

print   oldWb;  #<xlrd.book.Book object at 0x000000000315C940>

newWb  =   copy(oldWb);

print   newWb;  #<xlwt.Workbook.Workbook object at 0x000000000315F470>

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" ;

==================================================

//写入方法二：

 

import   xlwt;

import   xlrd;

#import xlutils;

from   xlutils.copy  import   copy;

 

#init xls file

#styleBlueBkg= xlwt.easyxf('pattern: pattern solid, fore_colour sky_blue;');

#styleBold   = xlwt.easyxf('font: bold on');

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 );

print   oldWb;  #<xlrd.book.Book object at 0x000000000315C940>

newWb  =   copy(oldWb);

print   newWb;  #<xlwt.Workbook.Workbook object at 0x000000000315F470>

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" ;

 

 

出自：http://www.crifan.com/python_append_new_data_into_existing_excel_xls_file/