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