Hi,
There is a task where I have to merge multiple excel spread sheets. The column number do not start from the first column and it can lie & start from any where or row in the spreadsheet.
There are blank rows in between data points which needs to be copied.
045401 641378-2019 2019079763 186851 2019-10-24 2019-10-27 EUR 5,919.58
045401 641379-2019 2019079764 190110 2019-10-24 2019-10-27 EUR 64.56
212716 00247743-2019 201910323 124320 2019-10-01 2019-10-01 EUR 61,001.44
212716 00248118-2019 201910680 128698 2019-10-09 2019-10-09 EUR 58,671.33
I donot want these rows to be copied to my destination or target excel file. I am using openpyxl and have trying to avoid these rows by using 'None' to identify blankrows but this logic is not working.
Code--
There is a task where I have to merge multiple excel spread sheets. The column number do not start from the first column and it can lie & start from any where or row in the spreadsheet.
There are blank rows in between data points which needs to be copied.
045401 641378-2019 2019079763 186851 2019-10-24 2019-10-27 EUR 5,919.58
045401 641379-2019 2019079764 190110 2019-10-24 2019-10-27 EUR 64.56
212716 00247743-2019 201910323 124320 2019-10-01 2019-10-01 EUR 61,001.44
212716 00248118-2019 201910680 128698 2019-10-09 2019-10-09 EUR 58,671.33
I donot want these rows to be copied to my destination or target excel file. I am using openpyxl and have trying to avoid these rows by using 'None' to identify blankrows but this logic is not working.
Code--
for row in range(a,ws1.max_row): colnum=3 for j in range(2,9): if ws1.cell(a,1).value != None: c=ws1.cell(row,j) ws2.cell(rownumber,colnum).value=c.value colnum=colnum+1 else: break; rownumber=rownumber+1