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

Params

• sheet any

setTagValue(sheet, tagID, value) ⇒ 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

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

Params

• source string | object - source Source element or sheet object.

• email Type.EmailParameters

create(parameters) ⇒ Type.Promise

Create a new new sheet.

Params

• parameters Type.Options

remove(target) ⇒ void

Remove a sheet.

Params

• target string

getReference(target) ⇒ Type.Spreadsheet

Get a reference to a spreadsheet.

Params

• target string

loadSheetFromDataArray(target, name, sheet) ⇒ void

Params

• target string

• name any

• sheet any

convertDataArrayToSheetRows(dataRows) ⇒ *

Params

• dataRows Array.<any>

createColumnFormats(dataRows) ⇒ Array.<any>

Params

• dataRows any

xyToA1(row, col) ⇒ string

Params

• row any

• col any

a1ToXy(ref) ⇒ *

Params

• ref string