Flow Decision Excel File Extension Checking

[Dr_Raza_Abidi_PhD]

Hi All: After selecting the Excel file through Select File Activity, making a condition, pl. see below:

Under the flow decision in Flow Chart:

filePath = “.xlsx” Then Message Box

I only want to check that the selected file must be an excel file.

Thanks,

[ppr (Peter Preuss)]

[Dr_Raza_Abidi_PhD]

@ppr : Here is the screenshot: I have stored the path of file in a filePath variable under the Select File Activity, then in the Flow Decision, making a condition:

If filePath = “.xlsx” Then True Else False. So, how to get filePath variable value in the flow decision IF condition.

[ppr (Peter Preuss)]

the select file activity will have an output - e-g- myFullFilePath
as mentioned above:
Path.GetExtension(myFullFilePath).toUpper.Equals(“.XLSX”)

can be used for the check within the Flow Decision Condition

[Dr_Raza_Abidi_PhD]

@ppr : Thanks a lot, I was trying with short of braces. Issue resolved now.

Many thanks,

But one more issue, pl guide and help.

I have loaded an excel file of 20500 records in it and my UiPath process is creating two new columns in the same loaded excel file and calculating the column.

The following error received:

Message: Job Stopped with an Unexpected exit code 0xE0434352
Exception Type: System.Exception

[ppr (Peter Preuss)]

@Dr_Raza_Abidi_PhD

0xE0434352

just have a search on the forum for the different strategies on how to handle. Otherwise create a new topic for this case

[Dr_Raza_Abidi_PhD]

Okay, thanks