How to open an excel file with a dynamic file name such that the file name is FXTB- date today using UI Path

0 votes
Oct 11, 2019 in RPA by Aiza
• 120 points
5,774 views

1 answer to this question.

0 votes
Hey Alza, I am trying to understand what is the problem here, because you can open any excel file by using Excel Application Scope. If you have more than 1 file, then you can use a loop to open them one by one. Why having a dynamic name is of concern to you?
answered Oct 14, 2019 by Abha
• 28,140 points
Hi,

The thing is when specifying the file name, I put * for the dynamic part as below:

Excel Name:

report1594211209235

The full path at the Excel Application Scope:

"C:\Users\XXX\Downloads\report*.xls"

But robot throws error as below probably because of that asterisk:

"Illegal characters in the path" but the name of the excel changes each day lets say, so I cannot put a fixed name.

How can i fix it?

Thank you in advance,

Best,

Cagla

Hi @Cagla,

For the Excel Application Scope, you have to give the actual file path. “*” is actually not going to work here. In case you have file names in a particular folder that changes from time to time, You may get the file names into an array first. And then loop through them to open the file.

Hope this helps!

Related Questions In RPA

0 votes
4 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

These are the steps to add two ...READ MORE

answered Aug 2, 2019 in RPA by Shivi Singhal
14,658 views
0 votes
1 answer

how to extract information from a pdf using regex and send that information to an excel spreadsheet?

You can use the following high level activities to ...READ MORE

answered Apr 9, 2020 in RPA by Karan
• 19,610 points
1,987 views
0 votes
1 answer

How to select an item in UiPath that starts with a string

use a wildcard in selector. make sure that ...READ MORE

answered May 21, 2018 in RPA by wrecker
• 3,110 points
3,411 views
0 votes
1 answer

How to select an item in UiPath that starts with a string

Just use a wildcard in selector. Given ...READ MORE

answered May 28, 2018 in RPA by wrecker
• 3,110 points
1,116 views
0 votes
1 answer

How to select an item in UiPath that starts with a string?

Just use a wildcard in selector. Given ...READ MORE

answered Jun 30, 2018 in RPA by wrecker
• 3,110 points
1,245 views
0 votes
1 answer

How to delete some specific sheets from an existing excel file using vb.net code?

You can create a output of Excel ...READ MORE

answered Jul 27, 2018 in RPA by ffdfd
• 5,550 points
3,109 views
0 votes
1 answer

What is the recommended way to open an application as part of a task in Automation Anywhere?

The recommended methods for opening an application ...READ MORE

answered Apr 1, 2019 in RPA by Iffath
• 1,180 points
2,821 views
0 votes
1 answer

How to read data from a excel, based on that data, check in the corresponding checkbox in browser appln? Uipath

Hi, to achieve this, you can perform ...READ MORE

answered Oct 10, 2019 in RPA by Abha
• 28,140 points
2,788 views
0 votes
1 answer

Is there any way to check whether a file exists or not using UiPath?

Hi @Raj, performing this check in UiPath ...READ MORE

answered Mar 20, 2019 in RPA by Abha
• 28,140 points
7,989 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP