List of usage examples for org.apache.poi.ss.usermodel Footer setCenter
void setCenter(String newCenter);
From source file:org.alanwilliamson.openbd.plugin.spreadsheet.functions.SpreadsheetSetFooter.java
License:Open Source License
public cfData execute(cfSession _session, List<cfData> parameters) throws cfmRunTimeException { cfSpreadSheetData spreadsheet = null; String left, center, right;// w w w.ja va2 s .c o m /* * Collect up the parameters */ spreadsheet = (cfSpreadSheetData) parameters.get(3); left = parameters.get(2).getString(); center = parameters.get(1).getString(); right = parameters.get(0).getString(); /* * Perform the insertion */ Sheet sheet = spreadsheet.getActiveSheet(); Footer footer = sheet.getFooter(); footer.setCenter(center); footer.setLeft(left); footer.setRight(right); return cfBooleanData.TRUE; }
From source file:ro.nextreports.engine.exporter.XlsExporter.java
License:Apache License
private void buildFooter() { if (bean.getReportLayout().getPageFooterBand().getColumnCount() == 0) { return;/*from w w w . j a v a2 s .c o m*/ } try { printPageFooterBand(); Footer footer = xlsSheet.getFooter(); footer.setCenter(footerS.toString()); } catch (QueryException ex) { ex.printStackTrace(); } finally { footerS = new StringBuilder(); } }