How to hide sheet in excel without using VBA code

Help Activities
, ,
1

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

2

Hey @Krishnakumar_Vasudevan ,

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

Hope it helps you out!

1 Like
3

Hi @Krishnakumar_Vasudevan ,

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

4

excel 2.12.3
system activity 21.4.1

5

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

6

HI,

We can achieve it using ClosedXML as the following sample.

image

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,

Mostrar/Ocultar Hoja de Excel
7

@Krishnakumar_Vasudevan

You can use invoke code and use the below

Cheers

8

may be this will help you using invoke code

9

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