Skip to end of metadata
Go to start of metadata




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
0Execution successful
1File open failure
9Other failures



All Plugins