How to paste data in excel sheet one after the other

[Jagadesh2494 (Jagadesh)]

Hi,

I have multiple excel files in a folder, however i managed to open those files using for each and start process but now i wanted to copy the data in those excel files one after the other in my master workbook. Can someone please help me on this?

[Lwissitoon (Luis Mateo)]

Hello
If you manage to open the excel files you could pass the values by excel document into a DataTable the pass into the sheet in the master workflow using Write Range activity

[Vijay_Kumar_C]

Hi @Jagadesh2494

i assume that all excel files are having same format - same number of columns.

please find attached code which will show “Select Folder” window.
select the folder where you are having multiple excel files.

code will create a consolidate file in “InputFiles\FinalMerge.xlsx” in this project.

To write First excel data i am using Write Range with headers.
After that i am using Append Range activity.

Hope this help you.

Regards,
Vijay.
CreateMasterExcel.zip (41.1 KB)

[Jagadesh2494 (Jagadesh)]

Thanks, Could you please provide the sample workflow? I wanted to know how your passing the values by excel file into a Data Table

[Jagadesh2494 (Jagadesh)]

Hi Vijay, Could you please resend the workflow

[amalmarella (Amal M)]

Hi @Jagadesh2494

in your workflow on left side , under project pane you will see dependency conflicts in red colour , right click and install them . it will work for you.

thanks,
amal.

[Vijay_Kumar_C]

Hey @Jagadesh2494

Attached code again.

CreateMasterExcel.zip (41.1 KB)

If you still get error please find the image and build logic.

Regards,
Vijay.