Spaces:
Sleeping
Sleeping
| from openpyxl import load_workbook | |
| import openpyxl as pyxl | |
| def rowWise(dF,sN,nCl,nRw): | |
| wb = load_workbook(filename = dF,data_only=True) | |
| ws=wb[sN] | |
| master=[] | |
| for r in range(2,nCl+1): | |
| for c in range(2,nRw+1): | |
| wdta=[] | |
| wdta.append(ws['A'+str(r)].value) | |
| wdta.append(ws.cell(column=c, row=1).value) | |
| wdta.append(ws.cell(column=c, row=r).value) | |
| master.append(wdta) | |
| ws = wb.create_sheet(title="RowData") | |
| i=1 | |
| for rec in master: | |
| for j in range(1,4): | |
| ws.cell(column=j,row=i).value=rec[j-1] | |
| i+=1 | |
| wb.save(filename = 'rwDta.xlsx') | |
| return 'rwDta.xlsx' |