text.append(_extractHeaderFooter(sheet.getHeader()));
HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = new HSSFSheet(); Header header = sheet.getHeader() //get header from workbook's sheet header.setCenter(HSSFHeader.font("COURIER", "Normal")+ HSSFHeader.fontSize((short) 15) + "Hello world" +new Date()); // set header with desire font style FileOutputStream fileOut = new FileOutputStream("C:\\book.xls"); workbook.write(fileOut);
public static void createTableHeader(HSSFSheet sheet, String[] tableHeader, String sheetname) { HSSFRow row = null; HSSFHeader header = sheet.getHeader(); header.setCenter(sheetname); row = sheet.createRow(0); for (int i = 0; i < tableHeader.length; i++) { setCell(row, i, tableHeader[i]); } }
private void setPrintSetup(HSSFSheet sheet, String displayName) { // sheet style HSSFPrintSetup setup = sheet.getPrintSetup(); setup.setLandscape(true); setup.setPaperSize(HSSFPrintSetup.A4_PAPERSIZE); // header and footer HSSFHeader header = sheet.getHeader(); header.setCenter(displayName); HSSFFooter footer = sheet.getFooter(); footer.setRight(FOOTER_RIGHT); footer.setLeft(FOOTER_LEFT); }
text.append(_extractHeaderFooter(sheet.getHeader()));
text.append(_extractHeaderFooter(sheet.getHeader()));
text.append(_extractHeaderFooter(sheet.getHeader()));
HSSFCell cellDescr = null; int paramSeq = 0; HSSFHeader header = sheet.getHeader(); StringBuffer strBuf = new StringBuffer(); if(!Globals.customizeFormFieldInfo() || customizedParamInfo.length()<=0) {
cell.setCellValue(reportTitle); cell.setCellStyle(styleHeader); HSSFHeader header = sheet.getHeader(); header.setCenter(HSSFHeader.font("Tahoma", "")+ HSSFHeader.fontSize((short) 9)+" " + reportTitle);