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

Name: Hide Excel sheet using UiPath | Macro
Uploaded: 2023-10-30T02:47:52Z
Description: @Krishnakumar_Vasudevan You can use invoke code and use the below [Hide Excel sheet using UiPath | Macro] Cheers

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,

Hey @Krishnakumar_Vasudevan , You can use Balareva excel activities to hide/unhide Excel sheets. Kindly refer below thread [image] BalaReva.Excel.Activities Community Feed Hi Friends, I have included the below new custom components in the package. 1.Create Workbook.(Cr…

[image] 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.

excel 2.12.3 system activity 21.4.1

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

@Krishnakumar_Vasudevan You can use invoke code and use the below [Hide Excel sheet using UiPath | Macro] Cheers

may be this will help you using invoke code [How to hide sheet of excel in UiPath?]

How to hide sheet in excel without using VBA code

Help Activities

Anil_G (Anil Gorthi) October 30, 2023, 2:47am 7

@Krishnakumar_Vasudevan

You can use invoke code and use the below

Cheers

Topic		Replies	Views
Mostrar/Ocultar Hoja de Excel StudioX excel	2	128	June 27, 2024
Hide Excel Sheet Activities excel , activities , studio , string , tutorial	3	2055	December 20, 2021
Hide/Unhide a worksheet in an Excel File Help excel , activities , question	3	7028	December 22, 2019
How to unhide the excel sheet Studio studio , question , tools	4	1965	November 30, 2021
How to hide the multiple excel sheets Studio studio , question , activities_panel	8	2626	December 20, 2021

How to hide sheet in excel without using VBA code

Related topics