Merging multi excel files into one sheet with colors as original sheets!

Feedback Robot
,
6

@myakkhaing

Best is to go with copy paste range activity that would copy all the formatting as well

To know what area to copy and all you can go with excel.sheet(“sheetname”).Rowcount give the number of rows as columns are fixed you know the full range

Cheers