Sheet
Sheet is an excel-like component to do data manipulation featuring resizable columns, ajax sorting, horizontal/vertical scrolling, frozen headers, keyboard navigation, multi cell selection with meta/shift keys, bulk delete/update and more.
Source
<h:form>
<p:sheet value="#{tableBean.cars}" var="car" scrollHeight="300">
<f:facet name="caption">
List of Cars
</f:facet>
<p:column headerText="Model" width="125" sortBy="#{car.model}">
<h:inputText value="#{car.model}" />
</p:column>
<p:column headerText="Year" width="125" sortBy="#{car.year}">
<h:inputText value="#{car.year}" onkeypress="return restrict(event)"/>
</p:column>
<p:column headerText="Manufacturer" width="125" sortBy="#{car.manufacturer}">
<h:inputText value="#{car.manufacturer}" />
</p:column>
<p:column headerText="Color" width="125" sortBy="#{car.color}">
<h:inputText value="#{car.color}" />
</p:column>
</p:sheet>
</h:form>
package org.primefaces.examples.view;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;
import java.util.UUID;
import org.primefaces.examples.domain.Car;
public class TableBean implements Serializable {
static {
colors = new String[10];
colors[0] = "Black";
colors[1] = "White";
colors[2] = "Green";
colors[3] = "Red";
colors[4] = "Blue";
colors[5] = "Orange";
colors[6] = "Silver";
colors[7] = "Yellow";
colors[8] = "Brown";
colors[9] = "Maroon";
manufacturers = new String[10];
manufacturers[0] = "Mercedes";
manufacturers[1] = "BMW";
manufacturers[2] = "Volvo";
manufacturers[3] = "Audi";
manufacturers[4] = "Renault";
manufacturers[5] = "Opel";
manufacturers[6] = "Volkswagen";
manufacturers[7] = "Chrysler";
manufacturers[8] = "Ferrari";
manufacturers[9] = "Ford";
}
private final static String[] colors;
private final static String[] manufacturers;
private List<Car> cars;
public TableBean() {
cars = new ArrayList<Car>();
populateRandomCars(cars, 50);
}
private void populateRandomCars(List<Car> list, int size) {
for(int i = 0 ; i < size ; i++)
list.add(new Car(getRandomModel(), getRandomYear(), getRandomManufacturer(), getRandomColor()));
}
public List<Car> getCars() {
return cars;
}
private int getRandomYear() {
return (int) (Math.random() * 50 + 1960);
}
private String getRandomColor() {
return colors[(int) (Math.random() * 10)];
}
private String getRandomManufacturer() {
return manufacturers[(int) (Math.random() * 10)];
}
private String getRandomModel() {
return UUID.randomUUID().toString().substring(0, 8);
}
}