How to write datatable data into my one drive excel file which is having same

Help Studio
, ,
1

Hi team,

I want to write dataTable data into my one drive excel file where iam having similar header names available and also in one drive excel file I have some extra headers how to do this

2

@Naveen_Kanike,

Use Write Range activity of UiPath.MicrosoftOffice365.Activities.Excel.WriteRange

Thanks,
Ashok :slight_smile:

3

how set up my one drive file path into write range activity of UiPath.microsoftoffice360

4

hi @ashokkarale ,

are you there?

5

@Naveen_Kanike,

It will require O365 Integration or Active directory Application with OneDrive Scope access.

Thanks,
Ashok :slight_smile:

6

A screenshot showing a configuration setup for Microsoft 365 Scope in an application with obfuscated connection details and options for authentication and writing range in an Excel sheet. (Captioned by AI)
A screenshot showing a configuration setup for Microsoft 365 Scope in an application with obfuscated connection details and options for authentication and writing range in an Excel sheet. (Captioned by AI)1920×2557 965 KB

I set up 360 connection but it’s asking the workbook file path? In write range activity

7

@Naveen_Kanike,

Use Find Files And Folders to find your desired file first and output of this activity would be DriveItem() pass first result drive item to write range (e.g., myWorkbooks(0))

Refer this documentation for more understanding.
Write Range Workbook Property

Find Files And Folders

Thanks,
Ashok :slight_smile:

8

Is there any alternative for the solution I don’t have azure access

9

@Naveen_Kanikem

Do you mean you can use Find files and folders? If you don’t have access to OneDrive, SharePoint scope access, you would require it.

Other solution would be downloading, updating and the reuploading the file.

Thanks,
Ashok :slight_smile:

10

You can sync your OneDrive locally and use it as a local file system.