SpreadsheetLib
Functions
destory(tabid)
hideUI(tabid)
hideGridLines(tabid)
clear(sheet) ⇒ void
setTagValue(sheet, tagID, value) ⇒ void
findTag(sheet, tagID) ⇒ *
showAsPDF(source, target) ⇒ Type.Promise
captureAsPdf(sheet, [pdfOptions]) ⇒ *
send(source, email) ⇒ Type.Promise
create(parameters) ⇒ Type.Promise
Create a new new sheet.
remove(target) ⇒ void
Remove a sheet.
getReference(target) ⇒ Type.Spreadsheet
Get a reference to a spreadsheet.
loadSheetFromDataArray(target, name, sheet) ⇒ void
convertDataArrayToSheetRows(dataRows) ⇒ *
createColumnFormats(dataRows) ⇒ Array.<any>
xyToA1(row, col) ⇒ string
a1ToXy(ref) ⇒ *
destory(tabid)
Params
tabid
string
hideUI(tabid)
Params
tabid
string
hideGridLines(tabid)
Params
tabid
string
clear(sheet) ⇒ void
void
Params
sheet
any
setTagValue(sheet, tagID, value) ⇒ void
void
Params
sheet
kendo.spreadsheet.Sheet
tagID
any
value
any
findTag(sheet, tagID) ⇒ *
*
Params
sheet
kendo.spreadsheet.Sheet
tagID
any
showAsPDF(source, target) ⇒ Type.Promise
Type.Promise
Params
source
string
|object
- Element id (as string) or sheet object.target
string
- Destination element id for the pdf.
captureAsPdf(sheet, [pdfOptions]) ⇒ *
*
Params
sheet
kendo.spreadsheet.Sheet
[pdfOptions]
Type.PdfOptions
send(source, email) ⇒ Type.Promise
Type.Promise
Params
source
string
|object
- source Source element or sheet object.email
Type.EmailParameters
create(parameters) ⇒ Type.Promise
Type.Promise
Create a new new sheet.
Params
parameters
Type.Options
remove(target) ⇒ void
void
Remove a sheet.
Params
target
string
getReference(target) ⇒ Type.Spreadsheet
Type.Spreadsheet
Get a reference to a spreadsheet.
Params
target
string
loadSheetFromDataArray(target, name, sheet) ⇒ void
void
Params
target
string
name
any
sheet
any
convertDataArrayToSheetRows(dataRows) ⇒ *
*
Params
dataRows
Array.<any>
createColumnFormats(dataRows) ⇒ Array.<any>
Array.<any>
Params
dataRows
any
xyToA1(row, col) ⇒ string
string
Params
row
any
col
any
a1ToXy(ref) ⇒ *
*
Params
ref
string
Last updated
Was this helpful?