Get Excel worksheet names without using Excel

[Clintonnn (Clinton)]

Hello,

I have a spreadsheet in the .xlsx format. This spreadsheet can have a dynamic number of worksheets, the worksheets will also be named dynamically.

REQUIREMENT:
I want to get the names of all worksheets present in the spreadsheet.

ISSUE:
The computer does not have Office installed on it and additional software cannot be installed. Also, packages from marketplace which may perform this function cannot be downloaded (the IT policy applied to by computer/network is very strict).

---

Does anyone know how I can get the names of worksheets without being able to open Excel or using other software?

[Anil_G (Anil Gorthi)]

@Clintonnn

You can try using invoke code and use closexml which does not required excel to be installed. Here is a sample code generated via chatgpt which can help as starter

    ' Path to your Excel file
    Dim filePath As String = "path\to\your\file.xlsx"
    
    ' Initialize a variable to hold the sheet names
    Dim sheetNames As String = ""

    ' Declare and load the workbook
    Dim workbook As XLWorkbook = New XLWorkbook(filePath)
    
    ' Iterate through the worksheets
    For Each sheet In workbook.Worksheets
        ' Add each sheet name to the string, separated by commas
        sheetNames &= sheet.Name & ", "
    Next
    
    ' Remove the trailing comma and space
    If sheetNames.EndsWith(", ") Then
        sheetNames = sheetNames.Substring(0, sheetNames.Length - 2)
    End If

    ' Output the sheet names
    Console.WriteLine("Sheet Names: " & sheetNames)

    ' Dispose of the workbook to free resources
    workbook.Dispose()

Library ClosedXML.Excel

Cheers

[Clintonnn (Clinton)]

Thanks, but that code doesn’t work for me:
Error:
error BC30002: Type ‘XLWorkbook’ is not defined. At line 8
error BC30002: Type ‘XLWorkbook’ is not defined. At line 8
error BC30574: Option Strict On disallows late binding. At line 13 Main.xaml

[lrtetala (Lakshman Reddy)]

Hi @Clintonnn

Check this

I wanted to get the excel sheet names with out opening the excel and then I want do so operation in each sheet

Hi @Naveen_Kanike Use the below code in Invoke Code: Dim app As Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Excel.Workbook app=New Microsoft.Office.Interop.Excel.ApplicationClass app.Visible=False app.AskToUpdateLinks=False wb=app.Workbooks.Open(ExcelFilePath,False,False) shArray=wb.Worksheets.Cast(Of Microsoft.Office.Interop.Excel.Worksheet).Select(Function(x) x.Name).ToArray wb.close Invoked Code Arguments: [image] Create a variable arr_SheetNames in you…

Get sheet name and info without using Excel application scope

Hi, I suppose there is no activity which we can get sheet name in Workbook category However, there is CloseXML library which is used by activities in Workbook category and you can get sheet name using it even if there is no Excel in your pc. I’ll attach sample as the following. Sample.xaml (6.3 KB) Regards,

Regards,

[singh_sumit (Sumit Singh Tariyal)]

Hie @Clintonnn use this activity to get all the names of sheets present in the excel
1- use excel application scope and pass the excel file
2- use get workbook sheets - and save the file name in the property section variable
3- use for each and pass the variable inside the for each

here is the list present in the excel

mark this solution if it finds you resolve your query
cheers Happy Automation