Get Excel worksheet names without using Excel

[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,