ExcelToText

Description

Creates a text field (string data type) representing the rows, columns, and cells of an Excel file (binary data type).


Supported file types

  • .xls
  • .xlsx
  • .xlsm

Use

  • Select an Excel argument. (Binary)
  • The function automatically detects a sheet by the sheet name, if the sheet by name cannot be detected, the function detects it by the index.
  • Enter the number of top Excel rows to skip.
    • The default value is 0, no rows to skip.
  • Enter the Output field name.
  • Click OK.

Hero Platform_ Example

An example of this function can be found in Hero Platform_'s library of examples.

Download the example titled "function_ExcelToText" to see an example of this function. 

Type

Formulas