Handsontable General Method

1.clear (): Erase data

2.createCol (index,amount,createautomatically): Adding columns

index : Column index, amount: Total number of columns added,createautomatically: As a number

Removecol (index,amount): Delete Column

CreateRow (Index): Add line

Removerow (index,amount): Deleting rows

3.get (Row,prop): Gets the value of a cell based on the line number and property index

GetAll (): Get all the data

Getcopyable (Row,prop): Gets the value of a single cell based on the line number and property index

Getcopyabletext (Start,end): Gets the value of the selected position

SATRT: Start selection of the Position object, end: Ends the selected position Object

GetRange (start,end,destination): Obtaining data by coordinates

SATRT: Start selection of Position object, end: End selected Position object, Destionation: Destination map index

GetText (Start,end): Gets the data for the target location

4.set (Row,prop,value,source): Sets the value of a single cell

Row : Line index, prop: column index, Value: New value, Source:hook plug -in provider

5.spliceCol (Col,index,amount): Add or Remove column data

col: Column index, index: Starting to change the array indexes, amount: Changing the number of data

Splicerow (Row,index,amount): Add or delete row data

Row : Line index, index: array index starting to change, amount: Changing the number of data

Handsontable General Method