How to merge same type of different excel file (excel is extracted from mail attachment) into one excel sheets

Help Activities
, ,
1

Dear All,

I want to merge different excel files (which number is not fixed & downloaded from mail attachments) into one excel sheet. the master excel file & different excel files have same number of columns, head title & same type of information. I already tried using “merge data table” but i failed. Can anybody help me to figure out my failure & give me a solutions. Thanks in advance// SojolCustomer Input file1.xlsx (10.1 KB)
Customer Input file2.xlsx (10.1 KB)
Customer Input file3.xlsx (10.1 KB)
Customer Main Input file.xlsx (9.9 KB)
New Capacity requirement-Mail automation.xaml (15.2 KB)

2

Hi,
We need to read datatable to be merged in MergeDataTable in advance.
So, the following sample helps you.

img20210919-1
img20210919-1858×984 24.6 KB

Sample20210919-1.zip (32.9 KB)

Regards,

1 Like
3

I can’t open your main.xaml file. could you please resend the file. then i will be able to see, what type of activity & VB.net expressions are used by you in your xaml file. Many thanks for your cooperation.

4

It works. I use “directory.getfiles()” VB expression instead of system.io.directory(). but it works. Many thanks for your suggestion. but somehow, your zip file contain 8KB main.xaml file, which can’t be opened in my laptop. could you please resend at your convenient time. Thanks in advance.

1 Like
5

Hi,

Alright. Hope the following helps you.

Main.xaml (7.3 KB)

Regards,

6

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