I need to copy one excel file data into another excel file by excluding rows which were hidden in source excel file.
https://i.stack.imgur.com/NPUK6.png As shown in the image, from the source excel file, I need to copy the data of row numbers 116,135 and 139 and exclude all the remaining rows which were hidden because of not matching the criteria. I have tried below code, but this is copying entire data into new excel sheet. wb = openpyxl.load_workbook('sourcefile.xlsx') sheet = wb.active sheet.title = 'Sheet1' wb.save('destinationfile.xlsx') -- https://mail.python.org/mailman/listinfo/python-list
