InfiniSuite SDK
  • Introduction
  • SDK & Scripting
    • Building Applications
    • Widgets
    • Classes
      • BaseApp
      • DashboardApp
      • EntityApp
      • FormApp
      • ListApp
      • Menu
      • Report
      • ReportQueryApp
      • Toolbar
      • TransactionApp
    • Libraries
      • ApiLib
      • AppLib
      • CacheLib
      • ChartLib
      • ExportLib
      • ImportLib
      • InfobarLib
      • LogLib
      • MainLib
      • MessageLib
      • RqlLib
      • ScriptLib
      • SpreadsheetLib
      • SystemLib
      • TabLib
      • TransactionGridLib
    • Sample Code
      • Entity App
      • Using Radiobuttons
  • REST API
    • Using the REST API
      • Entity Endpoint Summary
      • Authentication
      • Filters
      • Using RQL to Query Data
    • REST Endpoints
      • Account
      • Address
      • Application
      • Box1099
      • Class
      • CompanySetup
      • Contact
      • Favorite
      • Form1099
      • Item
      • Job
      • List
      • ListItem
      • Log
      • Note
      • Relationship
      • SalesTax
      • SalesTaxGroup
      • SalesTaxGroupItem
      • Task
      • Term
      • Transaction
      • TransactionDetail
      • Unit
  • Data Model & Schema
    • Data Model
    • Business Object Schemas
    • Tables
      • account
      • address
      • class
      • companysetup
      • contact
      • item
      • job
      • lead
      • list
      • listitem
      • relationship
      • task
      • term
      • transaction
      • unit
    • Views
      • accountbalanceview
      • accountbalanceyearmonthview
      • accountviewcompact
      • addressview
      • billview
      • classview
      • contactview
      • customerbalance
      • customerinvoicebodetail
      • customerinvoiceboheader
      • customerinvoicetotal
      • customeropeninvoices
      • customeropeninvoicetotal
      • customerpaymenttotal
      • itemview
      • listitemview
      • modelrelationview
      • openbillview
      • salestaxgroupitemview
      • scriptview
      • taskview
      • transaction_balance_view
      • transactiondetailview
      • transactiondetailviewcompact
      • transactiondetailviewnooffset
      • transactiondetailviewoffset
      • transactionview
      • transactionviewcompact
      • trialbalanceview
      • vendorbalance
  • Reference
    • Account Types
    • Field Types
    • Script Types
    • Tab Types
    • Transaction Types
    • Grid Filters
  • Setup & Configuration
    • Application Manager
    • Schema Manager
    • Script Manager
    • Bundle Manager
    • Text Localization
  • License
    • Open Source Licenses
Powered by GitBook
On this page
  • 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
  • remove(target) ⇒ void
  • getReference(target) ⇒ Type.Spreadsheet
  • loadSheetFromDataArray(target, name, sheet) ⇒ void
  • convertDataArrayToSheetRows(dataRows) ⇒ *
  • createColumnFormats(dataRows) ⇒ Array.<any>
  • xyToA1(row, col) ⇒ string
  • a1ToXy(ref) ⇒ *

Was this helpful?

  1. SDK & Scripting
  2. Libraries

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

PreviousScriptLibNextSystemLib

Last updated 5 years ago

Was this helpful?