Programmatically changes

Jspreadsheet has a comprehensive number of native methods to programmatically interact with your javascript spreadsheet and its data.

Go to a working example

General Methods

Method	Example
getData: Get the full or partial table data @Param boolan onlyHighlighedCells - Get only highlighted cells	spreadsheet.getData([bool]);
getJson: Get the full or partial table data in JSON format @Param boolan onlyHighlighedCells - Get only highlighted cells	spreadsheet.getData([bool]);
getRowData: Get the data from one row by number @Param integer rowNumber - Row number	spreadsheet.getRowData([int]);
setRowData: Set the data from one row by number @Param integer rowNumber - Row number @param array rowData - Row data	spreadsheet.setRowData([int], [array]);
getColumnData: Get the data from one column by number @Param integer columnNumber - Column number	spreadsheet.getColumnData([int]);
setColumnData: Set the data from one column by number @Param integer columnNumber - Column number @Param array colData - Column data	spreadsheet.setColumnData([int], [array]);
setData: Set the table data @Param json newData - New json data, null will reload what is in memory.	spreadsheet.setData([json]);
setMerge: Merge cells @Param string columnName - Column name, such as A1. @Param integer colspan - Number of columns @Param integer rowspan - Number of rows	spreadsheet.setMerge([string], [int], [int]);
getMerge: Get merged cells properties @Param string columnName - Column name, such as A1.	spreadsheet.getMerge([string]);
removeMerge: Destroy merged by column name @Param string columnName - Column name, such as A1.	spreadsheet.removeMerge([string]);
destroyMerged: Destroy all merged cells	spreadsheet.destroyMerge();
getCell : get current cell DOM @Param string columnName - str compatible with excel, or as object.	spreadsheet.getCell([string]);
getLabel : get current cell DOM innerHTML @Param string columnName - str compatible with excel, or as object.	spreadsheet.getLabel([string]);
getValue: get current cell value @Param mixed cellIdent - str compatible with excel, or as object.	spreadsheet.getValue([string]);
getValueFromCoords: get value from coords @Param integer x @Param integer y	spreadsheet.getValueFromCoords([integer], [integer]);
setValue: change the cell value @Param mixed cellIdent - str compatible with excel, or as object. @Param string Value - new value for the cell @Param bool force - update readonly columns	spreadsheet.setValue([string], [string], [bool]);
setValueFromCoords: get value from coords @Param integer x @Param integer y @Param string Value - new value for the cell @Param bool force - update readonly columns	spreadsheet.getValueFromCoords([integer], [integer], [string], [bool]);
resetSelection: Reset the table selection @Param boolean executeBlur - execute the blur from the table	spreadsheet.resetSelection([bool]);
updateSelection: select cells @Param object startCell - cell object @Param object endCell - cell object @Param boolean ignoreEvents - ignore onselection event	spreadsheet.updateSelection([cell], [cell], true);
updateSelectionFromCoords: select cells @Param integer x1 @Param integer y1 @Param integer x2 @Param integer y2	spreadsheet.updateSelectionFromCoords([integer], [integer], [integer], [integer]);
getWidth: get the current column width @Param integer columnNumber - column number starting on zero	spreadsheet.getWidth([integer]);
setWidth: change column width @Param integer columnNumber - column number starting on zero @Param string newColumnWidth - New column width	spreadsheet.setWidth([integer], [integer]);
getHeight: get the current row height @Param integer rowNumber - row number starting on zero	spreadsheet.getHeight([integer]);
setHeight: change row height @Param integer rowNumber - row number starting on zero @Param string newRowHeight- New row height	spreadsheet.setHeight([integer], [integer]);
getHeader: get the current header by column number @Param integer columnNumber - Column number starting on zero	spreadsheet.getHeader([integer]);
getHeaders: get all header titles	spreadsheet.getHeaders();
setHeader: change header by column @Param integer columnNumber - column number starting on zero @Param string columnTitle - New header title	spreadsheet.setHeader([integer], [string]);
getStyle: get table or cell style @Param mixed - cell identification or null for the whole table.	spreadsheet.getStyle([string]);
setStyle: set cell(s) CSS style @Param mixed - json with whole table style information or just one cell identification. Ex. A1. @Param k [optional]- CSS key @Param v [optional]- CSS value	spreadsheet.setSyle([object], [string], [string]);
resetStyle: remove all style from a cell @Param string columnName - Column name, example: A1, B3, etc	spreadsheet.resetStyle([string]);
getComments: get cell comments @Param mixed - cell identification or null for the whole table.	spreadsheet.getComments([string]);
setComments: set cell comments @Param cell - cell identification @Param text - comments	spreadsheet.setComments([string], [string]);
orderBy: reorder a column asc or desc @Param integer columnNumber - column number starting on zero @Param smallint sortType - One will order DESC, zero will order ASC, anything else will toggle the current order	spreadsheet.orderBy([integer], [boolean]);
getConfig: get table definitions	spreadsheet.getConfig();
insertColumn: add a new column @Param mixed - num of columns to be added or data to be added in one single column @Param int columnNumber - number of columns to be created @Param boolean insertBefore @Param object properties - column properties	spreadsheet.insertColumn([mixed], [integer], [boolean], [object]);
deleteColumn: remove column by number @Param integer columnNumber - Which column should be excluded starting on zero @Param integer numOfColumns - number of columns to be excluded from the reference column	spreadsheet.deleteColumn([integer], [integer]);
moveColumn: change the column position @Param integer columnPosition @Param integer newColumnPosition	spreadsheet.moveColumn([integer], [integer]);
insertRow: add a new row @Param mixed - number of blank lines to be insert or a single array with the data of the new row @Param integer rowNumber - reference row number @param boolean insertBefore	spreadsheet.insertRow([mixed], [integer], [boolean]);
deleteRow: remove row by number @Param integer rowNumber - Which row should be excluded starting on zero @Param integer numOfRows - number of lines to be excluded	spreadsheet.deleteRow([integer], [integer]);
moveRow: change the row position @Param integer rowPosition @Param integer newRowPosition	>spreadsheet.moveRow([integer], [integer]);
download: get the current data as a CSV file @Param bool - true to download parsed formulas.	spreadsheet.download([bool]);
getMeta: get the table or cell meta information @Param mixed - cell identification or null for the whole table.	spreadsheet.getMeta([string]);
setMeta: set the table or cell meta information @Param mixed - json with whole table meta information.	spreadsheet.setMeta([mixed]);
fullscreen: Toogle table fullscreen mode @Param boolan fullscreen - define fullscreen status as true or false	spreadsheet.fullscreen([bool]);
getSelectedRows: Get the selected rows @Param boolean asIds - Get the rowNumbers or row DOM elements	spreadsheet.getSelectedRows([bool]);
getSelectedColumns: Get the selected columns @Param boolan asIds - Get the colNumbers or row DOM elements	spreadsheet.getSelectedColumns([bool]);
showIndex: show column of index numbers	spreadsheet.showIndex();
hideIndex: hide column of index numbers	spreadsheet.hideIndex();
search: search in the table, only if directive is enabled during inialization. @Param string - Search for word	spreadsheet.search([string]);
resetSearch: reset search table	spreadsheet.resetSearch();
whichPage: Which page showing on jspreadsheet - Valid only when pagination is true.	spreadsheet.whichPage();
page: Go to page number- Valid only when pagination is true. @Param integer - Go to page number	spreadsheet.page([integer]);
undo: Undo last changes	spreadsheet.undo();
redo: Redo changes	spreadsheet.redo();

Edit this page on GitHub