Excel Get Worksheet as Collection

[Digital_WorkerB]

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?

--------------------------------------------------
Disclaimer: This content was auto-posted from Stackoverflow. The original Stackoverflow question is here Stackoverflow Post, posted by b_ewood.

[JerinJose]

Is your hidden columns have a null Header? BP has a Extended Excel VBO which can include columns with Null Header. Try using that​

------------------------------
Jerin Jose
RPA Product SME
EY
Asia/Kolkata
------------------------------