Doubt in preparation exam

In this question of the questionnaire:

I have answered AddHeaders, thinking that it was the correct one, because otherwise the format would not be correct, but at the end of the questionnaire it marks it as incorrect.
Should it be SheetName? So that it finds the table that is intended to be read, regardless of whether the headers are added or not.
What do you think?

@Antonio_Perez,

I think it’s a tricky question. The focus is on property ensuring returning all rows and not the adding column names.

What property should be configured to ensure that the Read Range Workbook activity returns all rows when reading a .xlsx file with headers and 300 rows of data?

As per me the answer would be Range: This specifies the range of cells to read. If left blank, it reads the entire sheet.

Try this one and share the result for my understanding as well :slight_smile:

But it’s not asking you to read 300 specific rows, it’s telling you that it wants to read ALL rows in a file that contains 300 rows and headers. The file contains 300 rows in total.
So I think you don’t need to specify the range, you want to read all rows, which is already those 300 rows. You can leave that property blank.
I was confused by the part that says the file contains headers.
In fact, I think, after failing, that the question asked in the statement is malicious, it tries to confuse, it has succeeded with me; and that it gives extra and irrelevant information, it could perfectly be: What property should be configured to ensure that the Read Range Workbook activity returns all rows when reading a .xlsx file?

@Antonio_Perez,

Makes sense! :male_detective:

My alternat choice is SheetName. It’s because they are asking about the property should be configured and Range and AddHeaders are optional. So ultimately SheetName is the one I think should be correct here as this is a mandatory or should be provided property.

1 Like

It’s a good point you make, because it’s the only necessary property, what’s more, if it’s not filled in the activity will throw an error, it won’t find the workbook.
Although with modern activities I’m not sure about anything, maybe the activity will set Sheet1 by default :smile:

@Antonio_Perez,

The question is about workbooks Read range activity, for this there is no default Sheet Name is being populated :v:

Hello, was reading this thread and I agree with this.

It’s honestly a hard question which looks quite easy on appearance, very easy to missunderstand, because, AddHeaders needs to be checked because there are headers in Excel file that we want to retrieve as well.

I don’t really understand what UiPath is testing with this question :confused:

2 Likes

Yes, it was just a joke.
I personally don’t understand the interest in UiPath for the modern experience, it seems to me that it is much less efficient and makes the code very dirty with so many unnecessary containers.

I think the key is to make sure it returns all rows in the file. Everything else is just distraction.
The activity will return all rows regardless of whether we maintain the formatting with headers or not. It doesn’t even say that the header is needed, just that all rows are retrieved.