python編程快速上手之第12章實踐項目參考答案(12.13.2)

標籤：rod   users   bsp   color   lan   range   upd   nbsp   pen   

#! python3# blankRowInserter.pyimport openpyxl,osos.chdir(‘C:\\Users\\Administrator\\Python35-32‘)n=int(input(‘rowNum‘))m=int(input(‘insertrowNum‘))name=(‘updatedProduceSales2.xlsx‘)wb = openpyxl.load_workbook(name)wbnew=openpyxl.Workbook()sheet = wb.get_active_sheet()sheetnew=wbnew.get_active_sheet()for rowNum in range(1, sheet.max_row+1):  if rowNum > n-1:    for colNum in range(1,sheet.max_column+1):      produceName = sheet.cell(row=rowNum, column=colNum).value      sheetnew.cell(row=rowNum+m, column=colNum).value = produceName  else:    for colNum in range(1,sheet.max_column+1):      produceName = sheet.cell(row=rowNum, column=colNum).value      sheetnew.cell(row=rowNum, column=colNum).value = produceName  wbnew.save(‘blankRowInserter.xlsx‘)

 

python編程快速上手之第12章實踐項目參考答案(12.13.2)