i have 10 excel files in a folder and each excel file have same headers with different data.
i am trying to consolidate all 10 files date into single excel file.
During this i am succesfully able to write into a single excel but headers are not displaying.
i enabled add headers .i am using append range while writing into excel.
can you help the better and short solution to do this.