rather mention like this and try once pls
MainDT = TempDT.Clone
@kaavya
still getting error
if you know any other way to merge excel file then can try that.
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
again getting this same error and i have tried with excel application scope as well
same error once again.
Fine
i have created a sample project
hope this would help you, its working fine
kaavya.zip (31.6 KB)
Cheers @kaavya
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
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