Consolidation of Multiple EXCEL Files into one Excel file - Resolved

Good Day,

Please help me fix my workflow.

On a daily basis, I have a new batch of excel files (file names: export.xlxs,export(1).xlxs…) that needs to be consolidated into one main excel file. (It has a same format, it just needs to be consolidated to make a daily monitoring.)

Initially, my workflow stopped from there since I am getting an error. Please see the attached image for reference.

Consolidation OF Excel FILE.xaml (8.0 KB)

image

Hi! There may be a .xaml file in the directory :slight_smile:
You may want to add if statement:
If item.ToString.Contains(".xlsx")

1 Like

Hi @Jan_Brian_Despi,

Thank, It worked but it did not proceed because of this error. No OPen excel file during the automation process

image

Hi! Maybe the excel file is open.
You may now close this topic by marking the solution :slight_smile:
Thanks :slight_smile:

Hi,
directory.GetFiles(SelectedFolder,"*.xlsx") this will give files of type excel
then you can add the values to new excel using append range activity.

Let us know if this helps,
Regards,
Pavan H

Hi @Jan_Brian_Despi,

Im sorry my friend, There are no active excel files before i ran the robot.

Try opening task manager. THere may be an EXCEL running
Or you may refer to this one :slight_smile:

Hi @Jan_Brian_Despi, Having an if activity filters only the excel file. Thanks.

Ive already got a solution for my previous concern.

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