Doing Unhide in Excel sheet/s

[yigit.aybey (Kuki_Shinobu)]

Hi all,

xlsSheet = CType(xlsWB.Sheets(“HideSheet Name”), Microsoft.Office.Interop.Excel.Worksheet)
xlsSheet.Visible = True

NOT : This code gives me an error => convertion error boolean to XlSheetVisibility

How can i do unhide specific sheet or sheets from excel via invoke vb.net ??

Thanks.

[Gokul001 (Gokul Balaji)]

HI @yigit.aybey

Try with below code

Sub UnhideAllWoksheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Visible = xlSheetVisible
Next ws
End Sub

Check out this thread

Basic concept of Macros

Hello Everyone, Hope you are doing good I would like to present this post who are looking for the expressions related to Macro How to Run the Macro Here are the steps to run the macros Go to the Developer tab Click on Macros In the Macro dialog box, select the macro you want to run. Click on Run button. [image] [image] Unhide All Worksheets Except the Active Sheet User needs to unhide all the workbook at one go, try to execute macros. Sub UnhideAllWoksheets() Dim ws As Worksheet For E…

Regards
Gokul

[yigit.aybey (Kuki_Shinobu)]

Thx for answer.

But i need to use inside of the invoke code. I cannot use macro

Thx.

[Gokul001 (Gokul Balaji)]

Why do need in Invoke code do you have any specific reason?

Check out the thread

VBA Hide (or Unhide) a Worksheet - VBA Code Examples

BalaReva.Excel.Activities

Hi Friends, I have included the below new custom components in the package. 1.Create Workbook.(Create a new worksheet) 2.Copy to File (Copy the worksheet to another excel file). 3.Copy to WorkBook (Copy the worksheet inside the workbook). 4.HideUnhide the worksheet 5.Protect Unprotect the worksheet [image] Create WorkBook Properties [image] Sample : CreateWorkbook.zip (18.5 KB) Copy To File This activity copies the work sheet to an another excel file. If the another file is not ex…

Regards
Gokul

[Gokul001 (Gokul Balaji)]

Hi @yigit.aybey

Look on the Video

Unhide Excel Sheet UiPath | Unhide Sheet Dynamically using Invoke VBA Activity in UiPath

Regards
Gokul

[yigit.aybey (Kuki_Shinobu)]

Hi

Sheets(“hidesheet”).Visible = True is not working. I’m doing opening the excel etc inside of the invoke code. This code error is => Sheets is and interface type and cannot be used as an expression.

Thx

[Sudharsan_Ka]

HI @yigit.aybey

Check with this code

Dim xlApp As Microsoft.Office.Interop.Excel.Application
Dim xlWorkbook As Microsoft.Office.Interop.Excel.Workbook
Dim xlWorksheet As Microsoft.Office.Interop.Excel.Worksheet
xlApp = New Microsoft.Office.Interop.Excel.ApplicationClass
Try
	xlWorkbook = xlApp.Workbooks.Open("Your excel path")
	xlWorksheet = CType(xlWorkbook.Worksheets("Your sheet name"),Microsoft.Office.Interop.Excel.Worksheet)
	xlWorksheet.Visible = Microsoft.Office.Interop.Excel.XlSheetVisibility.xlSheetHidden
    xlApp.Visible = False
	xlWorkbook.Save
	xlWorkbook.Close
Catch ex As Exception
	Throw ex
	
Finally
	xlApp.Quit
End Try

Regards
Sudharsan

[supermanPunch (Arpan)]

@yigit.aybey

xlsSheet.Visible = True

Hi @yigit.aybey ,

Maybe changing the above to the below Expression would work :

xlsSheet.Visible = Microsoft.Office.Interop.Excel.XlSheetVisibility.xlSheetVisible

Let us know if it results in an error.

[Gokul001 (Gokul Balaji)]

Check out this thread @yigit.aybey

How to get only unhidden sheet names in excel

Hi @Akanksha_Patil1 , Alternately, we could use Invoke Code Activity to get the Sheet names (Visible/Hidden) using Interop.Excel Could you Check the below workflow : Excel_Get_HiddenAndUnhiddenSheets.zip (13.1 KB) Let us know if this doesn’t help.

Regards
Gokul

[yigit.aybey (Kuki_Shinobu)]

Thanks for your all helps guys. @Gokul001 @Sudharsan_Ka @supermanPunch