Excel Get Worksheet as Collection

Question

I am new to RPA/Blue Prism.

I have a problem with the Action "Get Worksheet as Collection". In the excel sheet are hidden columns and these are not found.

Blue Prism returns error message:

Internal: Could not execute code stage because exception thrown by code stage: Column 17 was not found.

I've already tried the other Get Worksheet * actions

How can I get Blue Prism to read the hidden columns or make it unhidden so that it can be read?

Answer 1

The problem was not the hidden lines. However, I have found the error it was the line breaks (char 10 +13). Thank you anyway!