If Excel is empty robot doesnt read cell

Help StudioX
,
1

Hi all,

I am currently working in a process in which robot must read few excel files that sometimes can be empty.

When they are empty it appears a error message that says:
“Excel file does not exist”

I use a read cell activity and after that an conditional “IF”. The conditional is: CellValue is nothing.

But the problem appears in the read cell activity.

Do you know how can I solve it?

Many thanks :slight_smile:

Kind Regards
Angel

2

@Angel_Llull,

this is not as clear, but you can use a “path exist activity” to check if file exists and use the read range activity to read the file, then use Not String.IsNullOrEmpty(DT.Count().ToString) and then you can read cell after knowing that the file exists and has some data

4

Hello @SenzoD,

I have used path exist activity and then a conditional to verify. I put, if file exists then read cell. At reading cell, appears the same message. So, the “path exist activity” confirms that the file exists, but at reading the file, it does not exist, when it is inside the folder…

Do you have other ideas?

Many thanks in advance!

5

mind sharing your workflow?

6

Hello!

It is working now! :slight_smile:

Many thanks for your support :slight_smile:

7

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