UiPath microsoft office 365 read range from excel

[Ritaman_Baral]

I am trying to read an excel from sharepoint. The starting range of column is “A4”.
What to pass in the range so that it starts reading from A4 and continues till it finds data

[jose.ordonez1 (Jose Ordonez)]

Hi Ritaman,
Please check the image below:

Cheers!

[Ritaman_Baral]

I need office 365 logic

[jose.ordonez1 (Jose Ordonez)]

Hi Ritaman,
The best way to do that is as follow:

1. Sync your sharepoint to your local computer or Virtual Machine.
2. Create a .txt file (Placeholder file) inside the folder, where the target file is. This is a trick to force Sharepoint to get the last version of the file.
3. Get the last version of the target file.
4. Use a read range activity
5. Finally you can delete the .txt file created (Placeholder file).

Hope it helps you!

[Jayesh_678 (Jayesh)]

To read an Excel file from SharePoint starting from a specific range, such as “A4”, and continuing until it finds data, you can use the Excel activities provided by UiPath. Specifically, you can use the “Read Range” activity with dynamic range.

Here’s how you can do it:

1. Use the “Excel Application Scope” activity to open the Excel file from SharePoint.
2. Inside the “Excel Application Scope” activity, use the “Read Range” activity.
3. In the “Read Range” activity, provide the starting cell as “A4” and leave the range field empty. This indicates that you want to read the range dynamically until the end of the data.

Here’s an example of how you can set up the “Read Range” activity:

• Range: “A4”
• SheetName: (name of your worksheet)
• DataTable: (output DataTable variable)

Leave the “Range” field empty so that it reads the range dynamically until the end of the data in the Excel sheet.

By providing the starting cell as “A4” and leaving the range field empty, the “Read Range” activity will automatically read the data from “A4” until it encounters an empty cell, effectively reading until the end of the data in the worksheet. This ensures that you capture all the data in the Excel file, starting from the specified cell.