Index: src/documentation/xdocs/hssf/quick-guide.xml =================================================================== RCS file: /home/cvspublic/jakarta-poi/src/documentation/xdocs/hssf/quick-guide.xml,v --- src/documentation/xdocs/hssf/quick-guide.xml 15 Aug 2002 14:13:34 -0000 1.7 +++ src/documentation/xdocs/hssf/quick-guide.xml 4 Sep 2002 00:46:01 -0000 @@ -30,6 +30,8 @@
  • Reading and writing
  • Use newlines in cells.
  • Create user defined data formats.
  • +
  • Set print area for a sheet.
  • +
  • Set page numbers on the footer of a sheet.
  • @@ -356,6 +358,45 @@ fileOut.close();
    + +
    + + HSSFWorkbook wb = new HSSFWorkbook(); + HSSFSheet sheet = wb.createSheet("format sheet"); + HSSFPrintSetup ps = sheet.getPrintSetup() + + sheet.setAutobreaks(true) + + ps.setFitHeight((short)1); + ps.setFitWidth((short)1); + + + // Create various cells and rows for spreadsheet. + + FileOutputStream fileOut = new FileOutputStream("workbook.xls"); + wb.write(fileOut); + fileOut.close(); + +
    + +
    + + HSSFWorkbook wb = new HSSFWorkbook(); + HSSFSheet sheet = wb.createSheet("format sheet"); + HSSFFooter footer = sheet.getFooter() + + footer.setRight( "Page " + HSSFFooter.page() + " of " + HSSFFooter.numPages() ); + + + + // Create various cells and rows for spreadsheet. + + FileOutputStream fileOut = new FileOutputStream("workbook.xls"); + wb.write(fileOut); + fileOut.close(); + +
    +