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.

Type

Formulas