Read Cell

Scopes

• Sites.Read.All

• Sites.ReadWrite.All

• Microsoft OneDrive & SharePoint connection - The connection for the Microsoft 365 account to use in the activity.
• Workbook - The Excel workbook to use. The method to specify the folder to be retrieved: Folder picker, Enter Id, Enter Url.

  • Workbook sample - The workbook template to use. The field is visible after clicking Use workbook template. Browse the OneDrive folders and select a workbook. In Studio Desktop, the option is available from the See more button menu next to Range type. To learn more, see Working with templates.

  • File/Folder picker option: Click the Folder icon to browse the OneDrive or SharePoint files/folders and select a spreadsheet. This option accepts input as IResource.

    • Use the See more button menu to use a variable or select the Reload Folder Data option if you've modified your folders and need to retrieve the latest data.

  • Enter Id option:

    • Workbook Id - The ID of the workbook of interest. This property supports String variables and string formatted values.
    • SharePoint site address - The URL of the SharePoint site that contains the file or folder. This property supports String variables and string formatted values. Open your SharePoint site in a browser and copy its URL, e.g., https://yourcompany.sharepoint.com/sites/ProductOfficial.
    • SharePoint document library - The document library within the indicated SharePoint site that contains the file or folder. This property supports String variables and string formatted values. Open the Documents tab in your SharePoint site and copy the URL, e.g., https://yourcompany.sharepoint.com/sites/ProductOfficial/Shared%20Documents/Forms/AllItems.aspx.

  • Enter Url option:

    • Workbook Url - The URL of the workbook of interest. This property supports String variables and string formatted values. Retrieve the URL by opening the file in a browser.
• Sheet/Named range - The sheet or named range where the cell is located, e.g., Sheet1!A1:B6. If it is a named range, it will read the first cell of the range. This field is prepopulated with information retrieved from the selected workbook. This property supports String variables and string formatted values. We don't recommend using special characters (#) or special character combinations ($@) for this field.

  • Select the Update Ranges option if you've modified your sheets and need to retrieve the latest data.

• Cell - The cell to read from, e.g., A1. Leave empty for named range. This property supports String variables and string formatted values.
  Note: Some special character combinations in the Sheet/Range name property can cause the activity to throw an error. For example, Sheet%Test is a valid input, but Sheet%44 isn’t (%44 is transformed into D).

Additional options

• What to read - The type of data that is read. The available options are Values, Values and Formulas, and Text.

• Values option:

  • Cell value type - The type of value that is read: General, Date and time, Date, Time, Number, Text.

• Read cell - The cell retrieved data. Automatically generated output variable. You can use it as it is or save it with a different name. You can use this in other activities, such as Write Cell.

See also:

• Excel Online activities
• Create Workbook
• Delete Range
• Write Cell