How to hide sheet in excel without using VBA code

[Krishnakumar_Vasudevan]

Hi Team ,
Do we have any option to hide sheet in excel without using VBA code . Also excel activities we are using in our project pretty old to avoid some errors .So delete sheet or hide sheets activities are not available .

Please advice…

regards
Krishna

[Vikas_M]

Hey @Krishnakumar_Vasudevan ,

You can use Balareva excel activities to hide/unhide Excel sheets.
Kindly refer below thread

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…

Hope it helps you out!

[supermanPunch (Arpan)]

@Krishnakumar_Vasudevan

Also excel activities we are using i

Hi @Krishnakumar_Vasudevan ,

Could you maybe share your Excel dependency/Package version used ? So that we can confirm on the methods/activities available.

[Krishnakumar_Vasudevan]

excel 2.12.3
system activity 21.4.1

[Krishnakumar_Vasudevan]

thanks for the help , i am not sure whether we can import and use in our organization . Please advice.

[Yoichi]

HI,

We can achieve it using ClosedXML as the following sample.

Using wb As New ClosedXML.Excel.XLWorkbook(filename)
    Dim sheet As ClosedXML.Excel.IXLWorksheet = wb.Worksheet(sheetName)
        sheet.Hide()
    wb.Save()
End Using

Sample20231030-3L.zip (9.3 KB)

Regards,

[Anil_G (Anil Gorthi)]

@Krishnakumar_Vasudevan

You can use invoke code and use the below

Hide Excel sheet using UiPath | Macro

Cheers

[Gayathri_Mk]

may be this will help you using invoke code

How to hide sheet of excel in UiPath?