I want to merge all excel files in the folder as total excel file. I have hundreds of excel files in the folder and I want to merge all the data as one excel file. First I used read range activity, to convert excel as datatable. And then I used merge data table to merge all the datatables. I can merge all the data as one excel but it takes a lot of time to finish. If there is any solution or workaround to decrease runtime or to improve efficiency and effectiveness of the workflow. If you know the solution or workaround, please share it with me. Thanks. Best regards.
hello Gokul, thanks for sharing it. I used the same steps of the video already but the execution time is long when you run hundreds of excel files. I want another solution or work around to decrease running time.
what about doing it programmatically (VB/C#) with Invoke code or Invoke VBA? I am not sure how much faster will it be, but it could cut some portion of the runtime.
I could try to write something for this, but it will take some time (like day or two). That is if all the files have the same structure.