How to get all the sheet names of excel without opening excel

Help Studio
3

Hi

Hope the below steps would help you resolve this

—use a excel application scope and pass the filepath as input and from that activity get the output with a variable of type Workbook named Out_workbook

—then use a assign activity like this to get the sheet names

Arr_sheetnames = out_workbook.GetSheets.ToArray()

Arr_sheetnames is a variable of type Array of string

Or

You can try with custom activities

Cheers @anishakotian400

1 Like