Home

Plugin : CSV

Author:Rex.Rainbow

Download

Properties

Delimiter

  • Set delimiter for splitting items.

Eval mode

  • Enable "Eval mode" for parsing value.
    • Options : ["No","Yes"]

Actions

0: Load

Action:Load table

  • Load table from csv string.
    • CSV string ( string ) : The csv string for loading.

Action:Load one table

  • Load table from JSON string.
    • JSON string ( string ) : JSON string.

Action:Load all tables

  • Load all tables from JSON string.
    • JSON string ( string ) : JSON string.

Convert

Action:Convert row

  • Convert cells type in a row.
    • Row ( string ) : The row index.
    • Type ( Combo ) : Conver type to numver.
      • Options : ["Integer","Float"]

Action:Convert col

  • Convert cells type in a col.
    • Col ( string ) : The column index.
    • Type ( Combo ) : Conver type to numver.
      • Options : ["Integer","Float"]

Delimiter

Action:Set delimiter

  • Set delimiter for splitting items.
    • Delimiter ( string ) : Set delimiter for splitting items.

Page

Action:Turn page

  • Turn the page.
    • Page ( string ) : The index of page.

Resize

Action:Append a column

  • Append a column.
    • Col ( string ) : Column index.
    • Value ( number or string ) : The initial value.

Action:Append a row

  • Append a row.
    • Row ( string ) : Row index.
    • Value ( number or string ) : The initial value.

Action:Remove a column

  • Remove a column.
    • Col index ( number or string ) : Column index.

Action:Remove a row

  • Remove a row.
    • Row index ( number or string ) : Row index.

Set

Action:Set value

  • Set the value in the table at current page.
    • Col ( string ) : The column index.
    • Row ( string ) : The row index.
    • Value ( number or string ) : The value to store.

Action:Clear

  • Clear all cells.

Action:Set value at page

  • Set the value in the table at a specific page.
    • Col ( string ) : The column index.
    • Row ( string ) : The row index.
    • Page ( string ) : The index of page.
    • Value ( number or string ) : The value to store.

Action:Add to

  • Add to the value in the table at current page.
    • Col ( string ) : The column index.
    • Row ( string ) : The row index.
    • Value ( number or string ) : The value to store.

Action:Add at page

  • Add to the value in the table at a specific page.
    • Col ( string ) : The column index.
    • Row ( string ) : The row index.
    • Page ( string ) : The index of page.
    • Value ( number or string ) : The value to store.

Sort

Action:Sort items in col

  • Sort items in col.
    • Col index ( string ) : Col index.
    • Order ( Combo ) : Sorting order of item.
      • Options : ["ascending","descending","logical ascending","logical descending"]

Action:Sort items in row

  • Sort items in row.
    • Row index ( string ) : Row index.
    • Order ( Combo ) : Sorting order of item.
      • Options : ["ascending","descending","logical ascending","logical descending"]

Expressions

CSV

Expression:TableToCSV

  • Transfer current table to csv string.

Col

Expression:NextCol

  • Get next col index of a col index in current table. Add 2nd parameter to a specific col index, or uses AtCol if no col index assigned.

Expression:PreviousCol

  • Get previous col index of a col index in current table. Add 2nd parameter to a specific col index, or uses AtCol if no col index assigned.

Delimiter

Expression:Delimiter

  • Get delimiter.

For Each

Expression:CurCol

  • Get the current column index in a For Each loop.

Expression:CurRow

  • Get the current row index in a For Each loop.

Expression:CurValue

  • Get the current value in a For Each loop.

Expression:CurPage

  • Get the current page index in a For Each loop.

JSON

Expression:TableToString

  • Transfer current table to JSON string.

Expression:AllTalbesToString

  • Transfer all tables to a JSON string.

Row

Expression:NextRow

  • Get next row index of a col index in current table. Add 2nd parameter to a specific rpw index, or uses AtRow if no row index assigned.

Expression:PreviousRow

  • Get previous row index of a col index in current table. Add 2nd parameter to a specific rpw index, or uses AtRow if no row index assigned.

Table: At

Expression:At

  • Get value from current table. Add page index at 3rd parameter to turn the page. Add default value at 4th parameter for invalid value.
    • Col ( number or string ) : The column index.
    • Row ( number or string ) : The row index.

Expression:AtCol

  • Get the column index in the last At expression.

Expression:AtRow

  • Get the row index in the last At expression.

Expression:AtPage

  • Get the page index in the last At expression.

Table: Count

Expression:ColCnt

  • Get column count.

Expression:RowCnt

  • Get row count.

Conditions

For each col

Condition:For each col

  • Repeat the event for each column in the table.

Condition:For each row in col

  • Repeat the event for each row in a column.
    • Col ( string ) : The column index.

For each page

Condition:For each page

  • Repeat the event for each page.

For each row

Condition:For each row

  • Repeat the event for each row in the table.

Condition:For each col in row

  • Repeat the event for each column in a row.
    • Row ( string ) : The row index.

In

Condition:Data in col

  • Return true if data in col.
    • Data ( number or string ) : Data to compare.
    • Col ( string ) : The col index.

Condition:Data in row

  • Return true if data in row.
    • Data ( number or string ) : Data to compare.
    • Row ( string ) : The row index.

Condition:Cell is valid

  • Return true if the cell is valid.
    • Col ( string ) : The col index.
    • Row ( string ) : The row index.

Condition:Has col

  • Return true if this column index is in table.
    • Col ( string ) : The col index.

Condition:Has row

  • Return true if this row index is in table.
    • Row ( string ) : The row index.