Contents
|
THIS PLUGIN IS DESIGNED TO “READ” BEFORE “WRITE”.
Be careful! Return-Value stores data, not file path even when you “WRITE”.
|
|
2. No functions can be inserted.
|
Right Text Bubble
Left Text Bubble
|
Right Text Bubble
Left Text Bubble
|
More tips about the Plugin [Return Value] types.
Right Text Bubble
Left Text Bubble
|
|
Then your plugin variable {{test.A2(4)}} will produce E2.
Your row 1 will become headers. Row 2 to 5 are the data.
Plugin variable does not support 1 row CSV.
Variable name
String will be stored internally.
You must set user-variable and assigned it here. (not an array)
Group name
CSV will be stored internally.
No need for pre-setting the user-variable. Group name becomes the variable group name. Columns and rows are indicated as in example below.
{{group name.A(1)}}
Note: Column is uppercase only.
Valuable name
In case, you desire to store the File path in a preset user variable, you can specify it here.
File path
File will be stored externally. It is either csv or txt. Full path need to be specified at File path. File does not need to be present. If the file not found, it would be generated automatically. If it is present, it would be overwritten.
1. Data only
By checking this checkbox, all functions (formulas) will be deleted and the new sheet/book will only contain data (values).
All functions and formulas will be deleted and lost forever.
2. Allow Overwrite
By checking this checkbox, the plugin will overwrite existing sheet/book and save it. The original sheet/book will be lost forever.
This function can result in loss of functions/formulas.
|
1. Find String
|
Output/Return Value
Cell ID/Cell IDs in CSV format.
2. Pivot
|
Output/Return Value
File path of the target file.
3. Show Data Range
Optional
- Sheet name
- Cell ID/Range
|
4. Clear Cell
|
Code | Meaning |
---|---|
0 | Execution successful |
1 | Execution failed |