Skip to main content

Task Office - Excel - Get Cell​

The Excel - Get cell Task reads the value of one cell, a range of cells or whole columns from a worksheet of an Excel workbook and writes the values to the output of the Task.

Excel - Get cell Task settings, with the Credentials, Select Excel file, Worksheet and Cell coordinates groups

The Main settings, Flow, On error, Conditions and TimeOut tabs are the same for every Task; see Job - Tasks.

The Task settings are on the Excel - Get cell tab and on the Output tab of the Task window.

Excel - Get cell tab​

  • Credentials: The Credential used to read the workbook, for example on a network share; see Credentials

    Select a Credential in the combo box, or click the Settings icon to add or edit Credentials.

  • Select Excel file: The full path of the workbook; it can contain Variables

  • Password: The password that opens a protected workbook, used only when the workbook is encrypted

Worksheet

  • Use first worksheet: Reads the first worksheet

  • Use specific worksheet: Reads the worksheet with the name you enter or select

    Click Get to list the worksheets of the workbook in Select Excel file. The Client reads that file, so the path must be reachable from the computer that runs the Client. The name can contain Variables.

Cell coordinates

Row and column numbers start at "1".

  • Cell by position: One cell, by Row and Column

  • Cell by reference (i.e. A3): One cell, by Cell reference, for example "A3"

  • Cells by position range: The cells from Row and Column to End row and End column

  • Cell by reference range (i.e. B2): The cells from Cell reference to End cell reference, for example "B2" to "D10"

  • Get all cells: Every row of the worksheet, for the first columns up to Number of columns

  • Get by column numbers: Every row of the worksheet, for the columns in Column numbers

    Separate column numbers with commas and give ranges with a hyphen, for example 1,3,5-7.

All coordinate fields can contain Variables.

Output tab​

These settings shape the output of the Task:

  • Field separator: The character between cells of a row, "Tab" by default

  • Text qualifier: None (the default), " or ', written around every cell value of a range

  • Line break: The character between rows, "CrLf" by default

  • Include column names: Adds a first line with the column letters ("A", "B" and so on)

    It has no effect with Get by column numbers.

Output and errors​

The output of the Task is the text of the cells as Excel displays it, with the rows separated by the Line break character. A workbook, worksheet or cell that cannot be read stops the Task with an error.