Need suggestion on below senerio …
I/p Excelfile - sheet 1(fixed template)
Col name : A B C D
O/p Excelfile sheet 2(fixed template)
Col name : A B Month Year C
In sheet 2,all cell in Month column has fixed value Ex. 1 and Year has 2019 in all cell.
My current approach: using default view.todataTable i am reading all entry of Column : A & B from sheet 1 and write range into sheet 2.
But for column : Month ,Year , C i am using write cell. All are working fine only issue is it taking long time if the entries are 300+
Any other aproach so it paste at one instant