Support Portal

for ProcessRobot and WinAutomation

Start a new topic
Answered

How to unhide columns in Excel

I have a Excel as input for process but it has columns hide and when I read it hide columns data is Empty. How I can get data in hide columns as well?


Best Answer

Best way to use SQL queries to read data. So it will get hidden columns data as well.


1 person has this question

You can run a macro to unhide columns. 


Here is an example that I found online that works. 


Sub sbHidingUnHideColumns()

 

'To Hide Columns B to D

Columns("B:D").EntireColumn.Hidden = True

 

'To UnHide Columns B to D

Columns("B:D").EntireColumn.Hidden = False

 

End Sub


Answer

Best way to use SQL queries to read data. So it will get hidden columns data as well.

Login or Signup to post a comment