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.
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.
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
Hi @Kirigirisu_Coin
Or you can use invoke Code
Hide Column.zip (10.4 KB)
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
I don’t know VBA at all, so it was very helpful to know that there is such a thing.
Thank you very much.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.