Is there any way to make a hidden column reappear in Excel?

I currently have a hidden column in Excel somewhere, but I can’t find it, and I want to search the whole Excel Range and make it all reappear.

Is it possible to do that with Uipath?

Thank you very much for your help.

Hi @Kirigirisu_Coin

You can try VBA by using invoke VBA activity,

Sub unhide()
  Columns.EntireColumn.Hidden = False
End sub

Below is the document for how to use invoke VBA activity,

Or you can also try balareve activity to hide/unhide columns

2 Likes

Hi @Kirigirisu_Coin
Or you can use invoke Code

Hide Column.zip (10.4 KB)
image

excelApp = New Microsoft.Office.Interop.Excel.ApplicationClass
excelWB = excelApp.Workbooks.Open(excelFilePath)
excelWS = CType(excelWB.Worksheets(excelSheet), Microsoft.Office.Interop.Excel.Worksheet)
excelWS.Range(rangeToHide).EntireColumn.Hidden = True
excelWB.Save
excelWB.Close
excelApp.Quit
1 Like

I don’t know VBA at all, so it was very helpful to know that there is such a thing.
Thank you very much.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.