p:dataExporter is nested in a command component and exports the DataTable given as target to Excel, PDF, CSV or XML; the TXT buttons use a custom exporter. pageOnly="true" exports only the current page instead of the whole dataset. In Excel and PDF a cell is aligned if the style or styleClass of its column contains "right" or "center".
<div class="card">
<h:form>
<div class="flex justify-content-between">
<div>
<h5>Standard</h5>
<p:commandButton value="XLS" styleClass="mr-2 mb-2">
<p:dataExporter type="xls" target="tbl" fileName="products"/>
</p:commandButton>
<p:commandButton value="XLSX" styleClass="mr-2 mb-2">
<p:dataExporter type="xlsxstream" target="tbl" fileName="products"/>
</p:commandButton>
<p:commandButton value="PDF" styleClass="mr-2 mb-2">
<p:dataExporter type="pdf" target="tbl" fileName="products"/>
</p:commandButton>
<p:commandButton value="CSV" styleClass="mr-2 mb-2">
<p:dataExporter type="csv" target="tbl" fileName="products" />
</p:commandButton>
<p:commandButton value="XML" styleClass="mr-2 mb-2">
<p:dataExporter type="xml" target="tbl" fileName="products"/>
</p:commandButton>
<p:commandButton value="TXT" styleClass="mr-2 mb-2">
<p:dataExporter type="txt" target="tbl" fileName="products"/>
</p:commandButton>
</div>
<div>
<h5>Page Only</h5>
<p:commandButton value="XLS" styleClass="mr-2 mb-2 p-button-outlined">
<p:dataExporter type="xls" target="tbl" fileName="products" pageOnly="true"/>
</p:commandButton>
<p:commandButton value="XLSX" styleClass="mr-2 mb-2 p-button-outlined">
<p:dataExporter type="xlsxstream" target="tbl" fileName="products" pageOnly="true"/>
</p:commandButton>
<p:commandButton value="PDF" styleClass="mr-2 mb-2 p-button-outlined">
<p:dataExporter type="pdf" target="tbl" fileName="products" pageOnly="true"/>
</p:commandButton>
<p:commandButton value="CSV" styleClass="mr-2 mb-2 p-button-outlined">
<p:dataExporter type="csv" target="tbl" fileName="products" pageOnly="true"/>
</p:commandButton>
<p:commandButton value="XML" styleClass="mr-2 mb-2 p-button-outlined">
<p:dataExporter type="xml" target="tbl" fileName="products" pageOnly="true"/>
</p:commandButton>
<p:commandButton value="TXT" styleClass="mr-2 mb-2 p-button-outlined">
<p:dataExporter type="txt" target="tbl" fileName="products" pageOnly="true"
exporter="#{dataExporterView.textExporter}"/>
</p:commandButton>
</div>
</div>
<p:dataTable id="tbl" var="product" value="#{dataExporterView.products}"
paginatorTemplate="{CurrentPageReport} {FirstPageLink} {PreviousPageLink} {PageLinks} {NextPageLink} {LastPageLink}"
paginator="true" rows="10" styleClass="mt-2">
<p:column>
<f:facet name="header">
<h:outputText value="Code"/>
</f:facet>
<h:outputText value="#{product.code}"/>
</p:column>
<p:column>
<f:facet name="header">
<h:outputText value="Name"/>
</f:facet>
<h:outputText value="#{product.name}"/>
</p:column>
<p:column styleClass="text-center">
<f:facet name="header">
<h:outputText value="Category"/>
</f:facet>
<h:outputText value="#{product.category}"/>
</p:column>
<p:column styleClass="text-right">
<f:facet name="header">
<h:outputText value="Quantity"/>
</f:facet>
<h:outputText value="#{product.quantity}"/>
</p:column>
<p:column styleClass="text-right">
<f:facet name="header">
<h:outputText value="Price"/>
</f:facet>
<h:outputText value="#{product.price}">
<f:convertNumber type="currency" />
</h:outputText>
</p:column>
</p:dataTable>
</h:form>
</div>