Read Hidden Columns from Excel

[_Amlansahoo]

Hi Team,

How can I read values from hidden cells in a excel.
If now I am trying to read values from excel it's not reading values for hidden fields.

Please help me on this if possible.

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------

[devneetmohanty07]

Hi,

The Key not present in dictionary error usually occurs if the handle which is being provided is incorrect as handle refers to the current instance of the workbook being stored in the dictionary variable. Can you cross check if any other actions before it which uses the handle on the same workbook is working fine ?

------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant
Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

[TamilarasiS]

Hi Devneet,


I am able to perform the action (open workbook, activate workbook and show) with the same handle and only in action Unhide rows I am getting the issue...

------------------------------
Tamilarasi S
Associate software engineer
TechMahindra
Asia/Kolkata
------------------------------

[devneetmohanty07]

Here are you using Excel VBO for the rest and Excel Enhanced VBO for this Unhide Row action? If yes, then you are likely going to face this error, the reason being is both are separate business objects and the dictionary item of one is not shared with another. I would recommend in such a case replacing the similar actions from Excel Enhanced VBO only.

Can you confirm on the same?

------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant
Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

[TamilarasiS]

Hi Devneet,

Thanks for your reply and After replaced all the actions to Excel Enhanced VBO, the code executed successfully. but the rows in my excel didn't get unhide.
Need to check whether the issue is with the excel.



------------------------------
Tamilarasi S
Associate software engineer
TechMahindra
Asia/Kolkata
------------------------------