Excel Read Column

RCA.Activities.Excel.ExcelReadColumn

Description

Read all data into column has determined

(* for 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 column 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 column data. By default, this is filled in with "A1".
  E.g: "A1"

Misc

• Public (Boolean) - Check if you want to public the activity. Remember to consider data security requirement before using this property.
• 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: [482156710] Excel Read Column

Options

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

Output

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