Excel Read Row

RCA.Activities.Excel.ExcelReadRow

Description

This activity allows you to reads the values of an Excel row beginning from the cell specified in the StartingCell field: and stores it in an lEnumerable<object> variable.

(* is mandatory)

In the body of activity

• Sheet name - The sheet you want to read.
  E.g: "Sheet1"
• Starting Cell - The cell from which to start extracting the row data. By default, this is filled in with "A1".
  E.g: "A1"

Properties

Input

• Sheet name (String)* - The sheet you want to read.
  E.g: "Sheet1"
• Starting Cell (String)* - The cell from which to start extracting the row data. By default, this is filled in with "A1".
  E.g: "A1"

Misc

• Public (CheckBox) - Check if you want to public it. Remember to consider data security requirement before using it.
• Display Name (String) - The name of this activity. You can edit the name of the activity to organize and structure your code better. E.g: Excel Read Row

Options

• Preserve Format (Boolean) - Selecting this check box keeps the formatting of the row that you want to read. By default, the check box is cleared.

Output

• Result (IEnumerable) - Stores the information from the specified spreadsheet row in an IEnumerable variable.

​