Office 365 Activity

[ajeshwari.desai]

How to use Read Range activity in MS Office 365(Excel Online)?

[AutomationX_by_Kiran]

Excel Online Means Sharepoint or Other?

[Parvathy (PS Parvathy)]

Hi @ajeshwari.desai

Download the UiPath Package UiPath.MicrosoftOffice365.Activities from Manage Packages. Use will find Read range Activity under that package.

Hope it helps!!
Regards,

[AutomationX_by_Kiran]

For that, you need to use Microsoft Office 365 Scope

Microsoft Office 365 Scope We have some Azure Details like Tenant, Application Id, and Application Secrete required and the Admin team needs to give Permission for your Email.

Only then can we able to read and Write online…

For your reference PFA link

Download SharePoint File using UiPath

Thank you…

[ajeshwari.desai]

@Parvathy
Thanks for quick response
What is the configuration needed for read range(ConnectionID)?

[ajeshwari.desai]

@AutomationX_by_Kiran ,
Is there any other way than share point and one drive?

[Parvathy (PS Parvathy)]

@ajeshwari.desai

What is the configuration needed for read range(ConnectionID)?

Hi @ajeshwari.desai
Connection ID property is used for database connection which connects UiPath cloud and Sharepoint. You can directly browse for workbook and give the range.
Hope it helps!!
Regards,

[Anil_G (Anil Gorthi)]

@ajeshwari.desai

Please first setiup office 365 then read rnage can be used inside the scope activity

Your azure admin can help you with this

https://docs.uipath.com/activities/other/latest/user-guide/microsoft-office-365-scope

Cheers