/
Excel Simple Read-3.419.1057

Excel Simple Read-3.419.1057

Dec 01, 2023

     

     

     

    Excel Simple Read

     

    Author: Kyobong An

     

    Description

    This plugin reads value from CSV or EXCEL file.

     

     

     

     

    Need help?

    Technical contact to tech@argos-labs.com

     

    May you search all operations,

     

     

     

     

    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

    Code

    Meaning

    Code

    Meaning

    0

    Execution successful

    1

    File open failure

    9

    Other failures