activities
latest
false
UiPath logo, featuring letters U and I in white

Productivity Activities

Last updated Apr 30, 2025

PREVIEW
Read Row

UiPath.MicrosoftOffice365.Activities.Excel.ReadRowConnections

Description

Uses the Microsoft Graph Get range API to retrieve the values of cells from a specified row (StartingCell) in a workbook (Workbook) worksheet (SheetName).

After retrieving the data from all cells in the row, the activity returns a dynamic DataRow.
Scopes

This activity requires the following scopes:

  • Sites.Read.All

OR

  • Sites.ReadWrite.All

Project compatibility

Windows | Cross-platform

Configuration

  • Microsoft OneDrive & SharePoint - The connection for the Microsoft 365 account to use in the activity.
  • Workbook - The DriveItem whose data is read.
  • Workbook sample - Select a file with the same ranges as the variable file. This field becomes visible when you select Use workbook template.
  • Sheet - The name of the sheet from which data is read. This property supports String variables and string formatted values.
  • Cell - The address of the starting cell of the row. All contiguous cells to the right of this are returned. Enter the address of a single cell in A1-style notation.This property does not support a range of cells (e.g., "A1:A5"). This property supports String variables and string formatted values.
Input
  • Value Type - The type of data that is read from the document. Use the drop-down list to select one of the following options:
    • Values - Default. Retrieves the coded value (i.e., backend) of the cells in the row. This might differ from the format value shown in the Excel worksheet (e.g., if the cell displays 23.00 in the worksheet, the coded value returned is 23).
    • Values and Formulas - Retrieves the values and formulas of the specified cell only (e.g., =SUM(A1,B1)).
    • Text - Retrieves the Excel worksheet value of the cell (e.g., if the cell displays 23.00 in the worksheet, the text value returned is 23.00).
Output
  • Row - The values of the row as an array of objects. This field supports only Object[] variables. Required if you plan to use the output data in subsequent activities.

How it works

The following steps and message sequence diagram is an example of how the activity works from design time (i.e., the activity dependencies and input/output properties) to run time.

  1. Complete the steps.
  2. Add the Microsoft Office 365 Scope activity to your project.
  3. Add an activity or run an external process that outputs a DriveItem object (e.g., Find Files and Folders, Create Workbook, Copy Item).
  4. Add the Read Row activity inside the Microsoft Office 365 Scope activity.
  5. Enter values for the Input properties.
  6. Create and enter a Object[] variable for the Output property.
  7. Run the activity.
    • Your input property values are sent to the GetRange API.
    • The API returns the Object[] value to your output property variable.


  • Description
  • Project compatibility
  • Configuration
  • How it works

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2025 UiPath. All rights reserved.