Merging excel files


#1

how to merge multiple excel files in one excel file then converting it to pdf
can, anyone help me?


#2

Hey!
First use Read Range to read the excel files, then use merge data table activity to merge the data table…then use the resultant data table to make the merged excel file using WriteRange activity!
And this thread will help you to convert it into PDF


#3

thanks for ur help.


#4

Was the solution helpful?


#5

actually, i’m getting errors. As the excel files i’m merging is the downloaded attachments from email.
so, it is showing the file is read only


#6

my purpose is to serach the email attachments in excel format with a particular subject line, then merge the downloaded excel files into one excel file then convert it to pdf and again mail the pdf…


#7

Main.xaml (11.8 KB)
this is my attachment.


#8

this way also i tried, but not getting the solution.Main.xaml (17.1 KB)


#9

Hey!
First use Read Range to read the excel files, then use merge data table activity to merge the data table then use the resultant data table to make the merged excel file using WriteRange activity!
and this will convert it into PDF


#10

i did the same but getting errors.Main.xaml (11.0 KB)

this is my attachment.


#11

Hey, when you are saving the attachments, save it in a particular folder!
Is “Attachment” the same directory where the project resides?
Also when you are passing “Attachments” in excel application scope it doesn’t know which file to read, you need to give the whole path i.e attachments\filename.xlsx.
That is why you are not getting the result.
I’m sure that it has something to do with directory in which you are saving!


#12

no, Attachments is the folder where the excel sheets are downloaded from the mail box.


#13

So you need to give the whole path! Like C:\Users\downloads\attachments,
Also when using excel application scope use the whole path i.e C:\Users\downloads\attachments\filename.xlsx


#14

if i have suppose 2 excel files, then how will i give the name of two files?


#15

You will have to use two excel application scopes for each file! :slight_smile:
And, of course two read range!
And then use merge data table activity to merge both the data tables!


#16


this is the error thrown.


#17

i tried doing that also but errors are coming


#18

That is because you are not giving the proper location of the excel files, also make sure that excel name does follow the above requirements that you sent, it should work very well.


#19

excel.xaml (8.9 KB)

Here is the workflow! :slight_smile:
I hope this will surely help you.
Make sure this package is installed:
image


#20

this is another i’m trying