ParamQuery Pro API Documentation

ParamQuery Pro

Demos
- Demos 9.x
- Demos 8.x
- Demos 7.x
- Demos 6.x
- Demos 5.6
- Demos 5.1
- Demos 4.x
- Demos 3.3.x - 3.4.x
- Demos 3.2
- Demos 2.x
API
- API 9.x
- API 8.x
- API 7.x
- API 6.x
- API 5.2.0 - 5.6.0
- API 5.1
- API 4.x
- Excel formulas
- Excel workbook
- API 3.3.0 - 3.4.x
- API 3.2.0
- API 2.x
Upgrade
Tutorial
FAQ
Download / Buy
Forum

Contact

PQGrid Best javascript grid

Options
- autofill
- autoRow
- autoRowHead
- autoRowSum
- bootstrap
- bubble
- collapsible
- colModel
  - align
  - cb
  - cls
  - collapsible
  - colModel
  - copy
  - dataIndx
  - dataType
  - denyAgg
  - denyGroup
  - denyPivot
  - editable
  - editModel
  - editor
  - exportRender
  - filter
  - format
  - formula
  - groupable
  - groupChange
  - halign
  - hidden
  - maxWidth
  - minWidth
  - nodrag
  - nodrop
  - parent
  - postRender
  - render
  - resizable
  - sortable
  - sortType
  - summary
  - title
  - tpCls
  - tpHide
  - type
  - validations
  - width
- columnBorders
- columnTemplate
- copyModel
- dataModel
  - beforeSend
  - contentType
  - data
  - dataType
  - error
  - getData
  - getUrl
  - location
  - method
  - postData
  - postDataOnce
  - recIndx
  - url
- detailModel
- dragColumns
- draggable
- editable
- editModel
- editor
- fillHandle
- filterModel
- flex
- formulas
- formulasModel
- freezeBorders
- freezeCols
- freezeRows
- groupModel
- height
- historyModel
- hoverMode
- hwrap
- maxHeight
- maxWidth
- mergeCells
- minWidth
- numberCell
- pageModel
- pasteModel
- postRenderInterval
- resizable
- roundCorners
- rowBorders
- rowHt
- rowHtHead
- rowHtSum
- rowInit
- scrollModel
- selectionModel
- showBottom
- showHeader
- showTitle
- showTop
- showToolbar
- sortable
- sortModel
- stringify
- stripeRows
- summaryData
- summaryOptions
- summaryTitle
- swipeModel
- title
- toolbar
- toolPanel
- trackModel
- treeModel
- trigger
- validation
- virtualX
- virtualY
- warning
- width
- wrap
Methods
- addClass
- addRow
- attr
- collapse
- Columns
- commit
- copy
- createTable
- data
- deleteRow
- destroy
- disable
- editCell
- editFirstCellInRow
- enable
- expand
- exportCsv
- exportExcel
- exportData
- filter
- flex
- focus
- getCell
- getCellHeader
- getCellsByClass
- getCellIndices
- getChanges
- getColIndx
- getColumn
- getColModel
- getData
- getEditCell
- getEditCellData
- getInstance
- getRow
- getRowData
- getRowIndx
- getRowsByClass
- getViewPortIndx
- goToPage
- Group
- hasClass
- hideLoading
- History
- hscrollbar
- importWb
- isDirty
- isEditableRow
- isEditableCell
- isValid
- isValidChange
- loadState
- off
- on
- one
- option
- pageData
- pager
- paste
- quitEditMode
- Range
- refresh
- refreshCell
- refreshCM
- refreshColumn
- refreshDataAndView
- refreshHeader
- refreshHeaderFilter
- refreshRow
- refreshToolbar
- refreshView
- removeAttr
- removeClass
- removeData
- reset
- rollback
- rowCollapse
- rowExpand
- rowInvalidate
- saveEditCell
- saveState
- scrollCell
- scrollColumn
- scrollRow
- scrollX
- scrollXY
- scrollY
- search
- Selection
- SelectRow
- setSelection
- showLoading
- sort
- toggle
- toolbar
- ToolPanel
- Tree
- updateRow
- vscrollbar
- widget
Events
- beforeCheck
- beforeColumnCollapse
- beforeExport
- beforeFillHandle
- beforeGroupExpand
- beforePaste
- beforeRowExpand
- beforeRowSelect
- beforeSort
- beforeTableView
- beforeTreeExpand
- beforeValidate
- cellBeforeSave
- cellClick
- cellKeyDown
- cellDblClick
- cellRightClick
- cellSave
- change
- check
- columnCollapse
- columnDrag
- columnOrder
- columnResize
- complete
- create
- dataReady
- editorBegin
- editorBlur
- editorEnd
- editorFocus
- editorKeyDown
- editorKeyPress
- editorKeyUp
- exportData
- filter
- group
- groupChange
- groupOption
- headerCellClick
- history
- load
- refresh
- refreshHeader
- refreshRow
- render
- rowClick
- rowDblClick
- rowRightClick
- rowSelect
- scroll
- scrollStop
- selectChange
- selectEnd
- sort
- toggle
- treeExpand
Utility Methods
- aggregate
- exportWb
- eachCell
- importXl
- formatNumber
- tableToArray
- xmlToArray
- xmlToJson

Version: 5.1.0

pqGrid
pqPager
pqSelect

ParamQuery Grid Pro API Documentation for Version 5.x

Options

Methods

Events

Utility Methods

Copyright © 2012 - Paramvir Dhindsa (http://paramquery.com)