Excel Online - Microsoft 365

Help Activities
, , , , ,
1

I have an Excel file on SharePoint and I want to read the table within the Excel file and have the output of the activity be a DataTable. However, I tried using the Excel Online - Microsoft 365 activity, and the output is Read Range or Range Information, but I needed a DataTable. I also tried with Excel Classic - Microsoft 365, but it requires a DriveItem, which I tried to retrieve using Find Files, but without success. Do you know any activity that reads directly from Excel on SharePoint without needing to make a local copy of the file?

uipath_act
The image shows an expanded menu of available actions under the "Excel Online" section within the "Microsoft Office 365" directory, including tasks like adding sheets, creating workbooks, and writing cells. (Captioned by AI)

2

Hi @marcella The datatype of Read Range property is infact a datatable. Please see the example below-

image
image3432Ă—1291 195 KB

Hope this helps, but please do let me know if you have any questions.

1 Like
3

Hi @marcella

You are using the Read Range activity of Office 365 right, you are using the correct one. The output of Read Range is the datatable create a variable in the Read Range field in properties.

Check the below image for better understanding,

image
image1518Ă—597 45.7 KB

Hope it helps!!

1 Like
4

Thank you, I saw that the output was a DataTable, but when I checked in the Immediate, the variable looked like this: [DataTable4]. Now with the “Output Data Table” , I can see the contents of the DataTable. :grinning:

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.