Excel Related Error

[Shweta]

Hi,

Good Morning.

Can anyone please help with a small query described below:

I have an excel file at a below location, where date is dynamic, which will change the other day bot will run.

C:\Blueprism\ExcelOperations\abc_16-Nov-2018.xlsx

To open this file, I am storing the path in a data item and then passing it in input parameters of Open Workbook. But its throwing error that file does not exists or is not a file.
I tried below two options, but none of them seems to be working. Please help.

C:\Blueprism\ExcelOperations\abc_&[FormattedDate]&.xlsx
C:\Blueprism\ExcelOperations\abc_[FormattedDate].xlsx

where Formatted Date stores : 16-Nov-2018

 

[sivagelli]

C:\Blueprism\ExcelOperations\abc_&[FormattedDate]&.xlsx

Try using calc stage with the below and use validate expression to verify if it is working as expected-

"C:\Blueprism\ExcelOperations\abc_" &[FormattedDate] &".xlsx"

 

[Shweta]

yes, this way its working.
Thanks.

 

[Shweta]

One more query related to this:
Appreciate, if you can help in that as well.

I need to send the same file as an attachment too in email.. And attachments accepts collection type. So, how can i store its path in Collection?

In path field, its shows text type. and I am unable to pass the data item also.

 

[sivagelli]

Define a collection with Field as Path.
Using Calc stage store the above path in to CollectionName.Path. Now you can use pass this in Send Message action.

 

[Shweta]

Is it possible, if you can show me with the help of screenshot?
That will be more clear.

 

[Mullapudi Ramya]

View attachment 1542476023347.png @Shweta

 

[Shweta]

Thanks Ramya.
But what, if we have date also appended in the text file name, which keeps on changing every other day.