https://community.blueprism.com/t5/Product-Forum/Excel-Get-Worksheet-as-Collection/m-p/93581#M43098 <P>I am new to RPA/Blue Prism.</P> <P>I have a problem with the Action 'Get Worksheet as Collection'. In the excel sheet are hidden columns and these are not found.</P> <P>Blue Prism returns error message: </P> <BLOCKQUOTE> <P>Internal: Could not execute code stage because exception thrown by code stage: Column 17 was not found.</P> </BLOCKQUOTE> <P>I've already tried the other Get Worksheet * actions</P> <P>How can I get Blue Prism to read the hidden columns or make it unhidden so that it can be read?</P> --------------------------------------------------<BR /> <B>Disclaimer:</B> This content was auto-posted from Stackoverflow. The original Stackoverflow question is here <A href="https://stackoverflow.com/questions/57592142/excel-get-worksheet-as-collection">Stackoverflow Post</A>, posted by <A href="https://stackoverflow.com/users/11957146/b-ewood">b_ewood</A>. Thu, 22 Aug 2019 11:01:00 GMT Digital_WorkerB 2019-08-22T11:01:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Get-Worksheet-as-Collection/m-p/93581#M43098 <P>I am new to RPA/Blue Prism.</P> <P>I have a problem with the Action 'Get Worksheet as Collection'. In the excel sheet are hidden columns and these are not found.</P> <P>Blue Prism returns error message: </P> <BLOCKQUOTE> <P>Internal: Could not execute code stage because exception thrown by code stage: Column 17 was not found.</P> </BLOCKQUOTE> <P>I've already tried the other Get Worksheet * actions</P> <P>How can I get Blue Prism to read the hidden columns or make it unhidden so that it can be read?</P> --------------------------------------------------<BR /> <B>Disclaimer:</B> This content was auto-posted from Stackoverflow. The original Stackoverflow question is here <A href="https://stackoverflow.com/questions/57592142/excel-get-worksheet-as-collection">Stackoverflow Post</A>, posted by <A href="https://stackoverflow.com/users/11957146/b-ewood">b_ewood</A>. Thu, 22 Aug 2019 11:01:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Get-Worksheet-as-Collection/m-p/93581#M43098 Digital_WorkerB 2019-08-22T11:01:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Get-Worksheet-as-Collection/m-p/93582#M43099 Is your hidden columns have a null Header? BP has a Extended Excel VBO which can include columns with Null Header. Try using that​<BR /><BR />------------------------------<BR />Jerin Jose<BR />RPA Product SME<BR />EY<BR />Asia/Kolkata<BR />------------------------------<BR /> Mon, 09 Sep 2019 05:07:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Get-Worksheet-as-Collection/m-p/93582#M43099 JerinJose 2019-09-09T05:07:00Z