I need to copy data from an excel workbookA to another workbookB .
WorkbookA has hidden rows . I only need to copy the visible rows from workbookA to workbookB.
I believe i have to iterate through each row and check for the visible property and then copy. But I am not able to do it .
I dont see a visible property for a row in excel.
Any ideas ?