Excel Simple Read

Required Input

• The source file either .csv or .xlsx

Optional Input

• Sheet name (.xlsx only)
• Cell range
  Following formats can be used ---

  A1:C30      for specific rage

  A:C            for multiple columns

  1:30           for multiple rows

  A                one column

  1                one row

Advanced Input

• Data only option (Good only with .xlsx when you want to read data (value) over formula)

Return Value

• String         Value or formula that was read from the source file
• CSV            Value or formula that was read from the source file
• File            Value or formula that was read from the source file

Return Code

0        Execution Successful

1        Open Error (Input file not found or input sheet not found

9    All other responses from the plugin

Parameter setting examples

xlsx file usage output String

csv file usage output String

  xlsx file usage output CSV

  csv file usage output CSV

  data only usage output String

Return Code