How do i read sheet names from excel using excel online activities?

[deepakchawla]

Hi Team,

I have to read sheet names from excel located on SharePoint using excel online activities of office 365 package . Can anyone tell me ?

Thanks in Advance.

Regards,
Deepak

[vrdabberu (Varunraj Dabberu)]

Hi @deepakchawla

Check the below thread

Use sheet index for sheet name in sharepoint excel read range

@adext, Try this way. Use For Each Sheet in Workbook activity Inside it, check CurrentItemIndex is same as your desired sheet index If step 2 true then do the Write Cell this way. [image] Full solution: [image] Thanks, Ashok

Regards

[deepakchawla]

Index is not going to help…I need a sheet name

[deepakchawla]

I have to first check if sheet name exist or not. if exist, we have to update excel else add sheet a then update excel.

[Archana_Gulli (Archana)]

@deepakchawla,

Connect to sharepoint where the excel is located then try to open the excel using file’s URL and using Get Sheets activity you will get a list of all the sheet names in the Excel file.

HAPPY AUTOMATION!!

[deepakchawla]

Thanks Archana for reply.

I am not able to find Get sheet activity under excel online package

[lrtetala (Lakshman Reddy)]

Hi @deepakchawla

Can you try like below

Regards,

[vrdabberu (Varunraj Dabberu)]

Hi @deepakchawla

Use the below code in Invoke Code to get all the sheet names:

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

Invoke Arguments:

You will get all the sheet names in an array variable.

Or you can try this process too:

Regards

[deepakchawla]

working fine. Thank you very much for your help

[chandresh_agarwal]

You can use for each excel sheet activity and get CurrentSheet.Name to get sheet name