Skip to main content
Excel Online

Table > Get data by row

Table > Get data by row

Gets the data of a specific row of a table in an Excel file hosted on OneDrive or SharePoint.


Options

Drive type

Select the drive type: SharePoint or OneDrive.

Account

Select or enter the OneDrive/SharePoint account.

Excel path in the drive

Enter the full path of the Excel file in the drive.

Excel sheet name

Enter the name of the tab that holds the table.

Table name

Enter the name of the table.

Table row number

Enter the index of the desired row. The index starts at 0 (zero).

Returns

  • Row data — Returns the values of each column of the given row.

Rules and Conditions

  • Every field is required.
  • The row index starts at 0 (zero).