How to get all Sheet names of excel using modern activities

Hello friends, Any one know how to get all sheet names of excel using modern activities. Is there any way to get without excel scope.

Thanks in advance

1 Like


Without scope ypu cannot get them

  1. either use classic get worksheets activity
  2. Use for each sheet activity and save each name to an array

this is how you can create list of sheetnames


Hi @aslam_ali1
Use Get Workbook Sheets which is an Classic activity.
If with Modern activities follow below steps
Use Excel File=> For Each Excel Sheet => Use Message box and give CurrentSheet.Name.

Use this code

Sub GetSheetNamesAndSave()
    Dim ws As Worksheet
    Dim outputText As String
    For Each ws In ThisWorkbook.Sheets
        outputText = outputText & ws.Name & vbCrLf
    Next ws
    Open "C:\Path\To\Output.txt" For Output As #1
    Print #1, outputText
    Close #1
End Sub

Write this in a text document and save that file.
Drag and drop Invoke VBA and pass the filepath.

Hope it helps!!

Hi @aslam_ali1 ,

Could you maybe check with the below workflow : (9.3 KB)

It uses DocumentFormat.OpenXml methods in Invoke Code activity to get the sheet names.

Let us know if this doesn’t work.

1 Like

Well u can get it with GET WORKBOOK SHEETS activity
Download example here

Or u can try this also


If that’s the case then u can try with coding options


Using vb net on invoke code activity

Dim excelApp As Microsoft.Office.Interop.Excel.Application
Dim excelBook As Microsoft.Office.Interop.Excel.Workbook

' Provide the path to your Excel file
Dim filePath As String = "YourFilePath.xlsx"

' Initialize Excel Application
excelApp = New Microsoft.Office.Interop.Excel.ApplicationClass()

' Open the Excel workbook
excelBook = excelApp.Workbooks.Open(filePath)

' Create a list to store sheet names
Dim sheetNames As New List(Of String)

' Loop through each worksheet and add its name to the list
For Each sheet As Microsoft.Office.Interop.Excel.Worksheet In excelBook.Sheets

' Close the workbook and Excel application

' Release COM objects to prevent memory leaks

' Now, the sheet names are stored in the sheetNames list
' You can use them as needed

Using python with “Run Python Script” activity

import pandas as pd

# Provide the path to your Excel file
file_path = "YourFilePath.xlsx"

# Read the Excel file into a Pandas DataFrame
xls = pd.ExcelFile(file_path)

# Get the sheet names
sheet_names = xls.sheet_names

# Output the sheet names

Hope this helps

Cheers @aslam_ali1

1 Like

Thank you all for your kind support :grinning: :grinning: :grinning:

1 Like

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