DataExporter - Exclude Columns
Particular columns can be excluded in exported document.
Documentation
<h:form>
<p:dataTable id="tbl" var="car" value="#{dataExporterView.cars}"
paginator="true" rows="10">
<p:column>
<f:facet name="header">
<h:outputText value="Id" />
</f:facet>
<h:outputText value="#{car.id}" />
</p:column>
<p:column exportable="false">
<f:facet name="header">
<h:outputText value="Year" />
</f:facet>
<h:outputText value="#{car.year}" />
</p:column>
<p:column>
<f:facet name="header">
<h:outputText value="Brand" />
</f:facet>
<h:outputText value="#{car.brand}" />
</p:column>
<p:column exportable="false">
<f:facet name="header">
<h:outputText value="Color" />
</f:facet>
<h:outputText value="#{car.color}" />
</p:column>
</p:dataTable>
<h:commandLink id="excel">
<p:graphicImage name="/demo/images/excel.png" />
<p:dataExporter type="xls" target="tbl" fileName="cars" />
</h:commandLink>
<h:commandLink>
<p:graphicImage name="/demo/images/xlsx.png" width="24"/>
<p:dataExporter type="xlsxstream" target="tbl" fileName="cars" />
</h:commandLink>
<h:commandLink id="pdf">
<p:graphicImage name="/demo/images/pdf.png" />
<p:dataExporter type="pdf" target="tbl" fileName="cars" />
</h:commandLink>
<h:commandLink id="csv">
<p:graphicImage name="/demo/images/csv.png" />
<p:dataExporter type="csv" target="tbl" fileName="cars" />
</h:commandLink>
<h:commandLink id="xml">
<p:graphicImage name="/demo/images/xml.png" />
<p:dataExporter type="xml" target="tbl" fileName="cars" />
</h:commandLink>
</h:form>
@Named
@RequestScoped
public class DataExporterView implements Serializable {
private List<Car> cars;
private Exporter<DataTable> textExporter;
@Inject
private CarService service;
@PostConstruct
public void init() {
cars = service.createCars(100);
textExporter = new TextExporter();
}
public List<Car> getCars() {
return cars;
}
public void setService(CarService service) {
this.service = service;
}
public Exporter<DataTable> getTextExporter() {
return textExporter;
}
public void setTextExporter(Exporter<DataTable> textExporter) {
this.textExporter = textExporter;
}
}
@Named
@ApplicationScoped
public class CarService {
private final static String[] colors;
private final static String[] brands;
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";
brands = new String[10];
brands[0] = "BMW";
brands[1] = "Mercedes";
brands[2] = "Volvo";
brands[3] = "Audi";
brands[4] = "Renault";
brands[5] = "Fiat";
brands[6] = "Volkswagen";
brands[7] = "Honda";
brands[8] = "Jaguar";
brands[9] = "Ford";
}
public List<Car> createCars(int size) {
List<Car> list = new ArrayList<Car>();
for(int i = 0 ; i < size ; i++) {
list.add(new Car(getRandomId(), getRandomBrand(), getRandomYear(), getRandomColor(), getRandomPrice(), getRandomSoldState()));
}
return list;
}
private String getRandomId() {
return UUID.randomUUID().toString().substring(0, 8);
}
private int getRandomYear() {
return (int) (Math.random() * 50 + 1960);
}
private String getRandomColor() {
return colors[(int) (Math.random() * 10)];
}
private String getRandomBrand() {
return brands[(int) (Math.random() * 10)];
}
private int getRandomPrice() {
return (int) (Math.random() * 100000);
}
private boolean getRandomSoldState() {
return (Math.random() > 0.5) ? true: false;
}
public List<String> getColors() {
return Arrays.asList(colors);
}
public List<String> getBrands() {
return Arrays.asList(brands);
}
}
