SpreadJS function

SpreadJS function is used to interact with Spread JS UI. User can use multiple operations like get, set, peek, click, dbclick(double click) and selectRows.

SPREADJS (get command)

Get command is used to get the value of the specified cell of the spreadJS UI.

Select SET command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select SPREADJS function. Select scmd as get, provide sid, snum, srow and scol.

Here, sid is the id of the spreadJS sheet, snum is sheet number, srow is sheet row, scol is sheet column.

It will return the output in a variable defined in Element Key.

SPREADJS (set command)

Set command is used to set the value at the specified cell of the spreadJS UI.

Select SET command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select SPREADJS function. Select scmd as set, provide sid, snum, srow, scelltype and scellinput.

Here, sid is the id of the spreadJS sheet snum is sheet number srow is sheet row scol is sheet column scelltype is text scellinput is the data that you want to enter in that cell.

SPREADJS (peek command)

Peek command is used to bring the focus on the specified cell of the spreadJS UI.

Select RUN command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select SPREADJS function. Select scmd as peek, provide sid, snum, srow and scol.

SPREADJS (click command)

Click command is used to click on the specified cell of the spreadJS UI.

Select RUN command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select SPREADJS function. Select scmd as click, provide sid, srow and scol.

SPREADJS (dbclick command)

Dbclick command is used to perform double click on the specified cell of the spreadJS UI.

Select RUN command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select SPREADJS function. Select scmd as dbclick, provide sid, srow and scol.

SPREADJS (selectRows command)

SelectRows command is used to select the specified rows of the spreadJS UI.

Select RUN command from the action dropdown and provide a variable name in Element key where output will be stored, edit parameter section and click on Form, select functions from the dropdown and select SPREADJS function. Select scmd as selectRows, provide sid, snum, srow and srowcount.