arya-blue
luna-amber
luna-blue
luna-green
luna-pink
nova-dark
nova-light
saga-blue
vela-blue
Sheet
Sheet Sheet fills a need that the PrimeFaces Datatable with in-cell editing does not fill. It can handle a large amount of data with editing single cells without submitting the entire sheet. Provides familiar spreadsheet navigation with TAB and SHIFT+TAB and familiar spreadsheet experience.

Features include:
  • Fast In-Cell Editing and Validation
  • Copy/Paste
  • Range Selection including Copy/Paste and Fill
  • Sorting
  • Filtering
  • Fixed Columns and Rows
  • Resizable Columns and Rows
  • Movable Columns and Rows
  • Ajax Updates and Validation
Based on Handsontable by Handsoncode.
Components and more
Documentation
Attributes (move mouse over the names to see data types)
Name Description
activeHeaderStyleClassActive header style class.
allowTabOffSheetAllow tab off sheet.Default is false.
bindingAn EL expression referring to a server side UIComponent instance in a backing bean.Default is generated.
caseSensitiveSortCase sensitive sort.Default is false.
commentedCellStyleClassCommented cell style class.
converterEL expression resolves to a converter instance or literal converter ID defining a component converter.
converterMessage
currentColStyleClassCurrent column style class.
currentHeaderStyleClassCurrent header style class.
currentRowStyleClassCurrent row style class.
currentSortByID of column currently used for sorting (internal).
emptyMessageMessage when no records.
errorMessageGlobal error message when sheet is in error.
extenderJavaScript function to extend Handsontable options.
filteredValueFiltered and sorted list of values.
fixedColsNumber of fixed columns when scrolling.
fixedRowsNumber of fixed rows when scrolling.
fixedRowsBottomNumber of fixed rows at bottom.
heightHeight in pixels.
idUnique identifier of the component in a namingContainer.Default is generated.
immediateWhen set true, process validations logic is executed at apply request values phase for this component.Default is false.
invalidCellStyleClassInvalid cell style class.
localeLocale.Default is en-US.
maxColsMaximum number of columns.
maxRowsMaximum number of rows.
minColsMinimum number of columns.Default is 0.
minRowsMinimum number of rows.Default is 0.
movableColsAllow columns to be moved.Default is false.
movableRowsAllow rows to be moved.Default is false.
noWordWrapStyleClassNo word wrap style class.
nullSortOrderNull sort order placement.Default is 1.
origSortOrderOriginal sort order for reset (internal).
placeholderCellStyleClassPlaceholder cell style class.
readOnlySheet read only.Default is false.
readOnlyCellStyleClassRead only cell style class.
renderedBoolean value to specify the rendering of the component, when set to false component will not be rendered.Default is true.
requiredMarks component as required.Default is false.
requiredMessage
resizableColsAllow columns to be resizable.Default is false.
resizableRowsAllow rows to be resizable.Default is false.
rowHeaderAn el expression resolving to a header for each row. Optional.
rowKeyUnique identifier of row data.
rowStyleClassStyle class for each row (EL).
selectedColumnSelected column index.
selectedLastColumnLast selected column index.
selectedLastRowLast selected row index.
selectedRowSelected row index.
selectionModeSelection mode: single, range, multiple.Default is multiple.
showColumnHeadersShow column headers.Default is true.
showRowHeadersShow row headers.Default is true.
sortByColumn/value expression to sort by (Object for correct type).
sortOrderSort direction.Default is ASCENDING.
stretchHHandsontable stretchH.
styleInline style of the component.
styleClassStyle class of the component.
tabindexTab index.Default is 0.
validatorA method expression referring to a method validating the input.
validatorMessage
valueThe value of the sheet (java.util.List).
valueChangeListenerA method binding expression referring to a method for handling a valuchangeevent.
varRequest-scope attribute name for the current row data.
widgetVarName of the client side widget.
widthWidth in pixels.
PrimeFaces Extensions Showcase - © 2011-2025,PrimeFaces: 16.0.0-SNAPSHOT,PrimeFaces Extensions: 16.0.0-SNAPSHOT,JSF: Apache MyFaces Core 4.0 - Impl 4.0.3,Server: Apache Tomcat (TomEE)/10.1.52 (10.1.4),Build time: 2026-03-06 07:52