Need help Append File activity

Learn Academy Feedback
, , ,
#1

All,

Need your help for this.

I have a scenario where i need to move all the files (excel) into a different location (shared one),
and i need to consolidate the all the sheets with the single one by keeping the same header of the individual sheet. I am using append activity,but i am seeing the results like this (screen shot attached), attached is also the xamlfile too

Please suggestAppendExcel.docx (83.7 KB) Merge Excel Data into Master Sheet.xaml (8.0 KB)

1 Like
#2

@Ram0803 In xaml you are using both write range and append range activity,remove write range activity.

#3

@inp

Thanks for this, it really worked, but in the master sheet, I am not seeing Headers

Screen shot attachedNo Headers

#4

@Ram0803 If you want headers you can use merge datable activity.
Please find the attached xaml Sample.zip (26.3 KB)

2 Likes
How to get the header using filtered datatable
#5

@inp

It worked… Thank you.

Regards,
Ram :v:

1 Like
#6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.