public static void copyPageSetup(Sheet destSheet, Sheet srcSheet) { Header header = srcSheet.getHeader(); Footer footer = srcSheet.getFooter(); if (footer != null) { destSheet.getFooter().setLeft(footer.getLeft()); destSheet.getFooter().setCenter(footer.getCenter()); destSheet.getFooter().setRight(footer.getRight()); } if (header != null) { destSheet.getHeader().setLeft(header.getLeft()); destSheet.getHeader().setCenter(header.getCenter()); destSheet.getHeader().setRight(header.getRight()); } }
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);
row = sheet.createRow(rowNum); header.setCenter(HSSFHeader.font("Tahoma", "")+ HSSFHeader.fontSize((short) font_header_title_size)+strBuf.toString());
public static void copyPageSetup(Sheet destSheet, Sheet srcSheet) { Header header = srcSheet.getHeader(); Footer footer = srcSheet.getFooter(); if (footer != null) { destSheet.getFooter().setLeft(footer.getLeft()); destSheet.getFooter().setCenter(footer.getCenter()); destSheet.getFooter().setRight(footer.getRight()); } if (header != null) { destSheet.getHeader().setLeft(header.getLeft()); destSheet.getHeader().setCenter(header.getCenter()); destSheet.getHeader().setRight(header.getRight()); } }