getData: Get the full or partial table data @Param boolan onlyHighlighedCells - Get only highlighted cells |
$('#my').jexcel('getData', false); |
setData: Update the table data @Param json newData - New json data, null will reload what is in memory. @Param boolean ignoreSpare - ignore configuration of minimal spareColumn/spareRows |
$('#my').jexcel('setData', [json], false); |
insertColumn: add a new column @Param integer numberOfColumns - Number of columns should be added @Param string headerTitle - Header title |
$('#my').jexcel('insertColumn', 1, { header:'Title' }); |
deleteColumn: remove column by number @Param integer columnNumber - Which column should be excluded starting on zero |
$('#my').jexcel('deleteColumn', 1); |
insertRow: add a new row @Param integer numberOfRows - Number of rows should be added |
$('#my').jexcel('insertRow', 1); |
deleteRow: remove row by number @Param integer rowNumber - Which row should be excluded starting on zero | $('#my').jexcel('deleteRow', 1); |
getHeader: get the current header by column number @Param integer columnNumber - Column number starting on zero |
$('#my').jexcel('getHeader', 2); |
setHeader: change header by column @Param integer columnNumber - column number starting on zero @Param string columnTitle - New header title |
$('#my').jexcel('setHeader', 1, 'Title'); |
getWidth: get the current column width @Param integer columnNumber - column number starting on zero |
$('#my').jexcel('getWidth', 2); |
setWidth: change column width @Param integer columnNumber - column number starting on zero @Param string newColumnWidth - New column width |
$('#my').jexcel('setWidth', 1, 100); |
orderBy: will reorder a column asc or desc @Param integer columnNumber - column number starting on zero @Param smallint sortType - Zero will toggle current option, one for desc, two for asc |
$('#my').jexcel('orderBy', 2); |
getValue: get current cell value @Param mixed cellIdent - str compatible with excel, or as object. |
$('#my').jexcel('getValue', 'A1'); |
setValue: change the cell value @Param mixed cellIdent - str compatible with excel, or as object. @Param string Value - new value for the cell |
$('#my').jexcel('setValue', 'A1'); |
updateSelection: select cells @Param object startCell - cell object @Param object endCell - cell object @Param boolean ignoreEvents - ignore onselection event |
$('#my').jexcel('updateSelection', [cell], [cell], true); |
download: get the current data as a CSV file. @Param none |
$('#my').jexcel('download'); |
getConfig: get the current value of one configuration by key @Param string configuration key |
$('#my').jexcel('getConfig', 'allowInsertColumn'); |
setConfig: set the value of one configuration by key @Param string configuration key, @Param mixed configuration value |
$('#my').jexcel('setConfig', 'allowInsertColumn', true); |
download: get the current data as a CSV file. @Param none |
$('#my').jexcel('download'); |
getStyle: get table or cell style @Param mixed - cell identification or null for the whole table. |
$('#my').jexcel('getStyle', 'A1'); |
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 |
$('#my').jexcel('setSyle', [ { A1:'background-color:red' }, { B1: 'color:red'} ]); |
getComments: get cell comments @Param mixed - cell identification or null for the whole table. |
$('#my').jexcel('getComments', 'A1'); |
setComments: set cell comments @Param cell - cell identification @Param text - comments |
$('#my').jexcel('setComments', 'A1', 'My cell comments!'); |
getMeta: get the table or cell meta information @Param mixed - cell identification or null for the whole table. |
$('#my').jexcel('getMeta', 'A1'); |
setMeta: set the table or cell meta information @Param mixed - json with whole table meta information. |
$('#my').jexcel('setMeta', [ A1: { info1:'test' }, { B1: { info2:'test2', info3:'test3'} } ]); |