Error in merging multiple excel files

rather mention like this and try once pls
MainDT = TempDT.Clone
@kaavya

merge datatable (3).xaml (9.8 KB)

Capture8 still getting error

if you know any other way to merge excel file then can try that.

1 Like

here you go with the xaml
kindly try and let know for any queries or clarfication
merge datatable (3).xaml (9.7 KB)

Cheeers @kaavya

Capture

again getting this same error and i have tried with excel application scope as well

kindly initailize this
image

Cheers @kaavya

same error once again.

1 Like

Fine
i have created a sample project
hope this would help you, its working fine
kaavya.zip (31.6 KB)

Cheers @kaavya

1 Like

is it working
kindly let know for any queries or clarification
i hope the reason would be the MainDT with global scope
keep that MainDT with scope with the for each alone
that would work
Cheers @kaavya

still getting same error:slightly_frowning_face:
it s working as you said but when i did same with my project its thorwing error

did we try this on the workflow buddy
Cheers @kaavya

1 Like

statemachine.zip (76.3 KB)
sequence contains merge operation

i have shared my workflow kindly have a look

MergeFileData.xaml (6.7 KB) excelfiles.zip (26.3 KB)
Hi @kaavya,
Please have a look to attached workflow. I have used yours files as input for merging.

Regards,
Rahul

1 Like