Consolidation of Multiple EXCEL Files into one Excel file - Resolved

Help
1

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
image448×829 16.1 KB

image

2

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
3

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

4

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

5

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

6

Hi @Jan_Brian_Despi,

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

7

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

8

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

Ive already got a solution for my previous concern.

9

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