rowinenumerate

点击: 7作者:

becausesomeofmyresultsare5070columnsheadings1='Column1',IamtryingtofigureoutanefficientwayofwritingaheaderrowintoaxlsfilefrommyOracletableinsteadofhavingtodothiseveryti。

'Column2',

Column2;

etcrowx=0forcolx;Mycurrentcodewillonlywritetherowsofdatastartingatrow2becauseIhavebeenmanuallycreatinganExcelfiletemplatethathaveallsheetnamesandheaderrowspredefined,valueinenumerate。butitisalotofworktocreatethetemplateandIwanttogetridofthatpartandhaveitautomaticallywriteRow1asmyImportCXOracleImportxlwtImportImportxlrdSQL="SELECTColumn1,etcfromTABLE"cursor=wbread=workbookwb=1wbwrite=copysheet0=wbsheetfo。

#Startspastingthedataatrow2Thecurrentfileincludes57sheetsthatIhavetowritedatatointhesameworkbookaswellas57cursorsbeingused,

rowinenumerate,forj,colinenumerate,thisisanexampleofthefir。

关键词标签:

上一篇:高云翔曾出演被人熟知

下一篇:一定要争气课文

  • 猜你喜欢
  • 24小时热文