Examples of HSSFFooter

org.apache.poi.hssf.usermodel.HSSFFooter
Class to read and manipulate the footer.
The footer works by having a left, center, and right side. The total cannot be more that 255 bytes long. One uses this class by getting the HSSFFooter from HSSFSheet and then getting or setting the left, center, and right side. For special things (such as page numbers and date), one can use a the methods that return the characters used to represent these. One can also change the fonts by using similar methods.
@author Shawn Laubach (slaubach at apache dot org)

Examples of org.apache.poi.hssf.usermodel.HSSFFooter

        filename = filename + "/EmbeddedChartHeaderTest.xls";
        FileInputStream fin = new FileInputStream( filename );
        HSSFWorkbook wb = new HSSFWorkbook( fin );
        fin.close();
        HSSFSheet s = wb.getSheetAt( 0 );
  HSSFFooter foot = s.getFooter();


  assertEquals("Bottom Left", foot.getLeft());
  assertEquals("Bottom Center", foot.getCenter());
  assertEquals("Bottom Right", foot.getRight());
    }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFooter

        // Row 1 Repeats on each page
        wb.setRepeatingRowsAndColumns(0,0,0,0,1);
        
        // Set Print Area, Footer
        wb.setPrintArea(0, 0, colCount, 0, rowCount);
        HSSFFooter footer = sheet.getFooter();
        footer.setCenter("Page " + HSSFFooter.page() + " of " + HSSFFooter.numPages());
        // Fit Sheet to 1 page wide but very long
        sheet.setAutobreaks(true);
        HSSFPrintSetup ps = sheet.getPrintSetup();
        ps.setFitWidth((short)1);
        ps.setFitHeight((short)9999);

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFooter

        filename = filename + "/EmbeddedChartHeaderTest.xls";
        FileInputStream fin = new FileInputStream( filename );
        HSSFWorkbook wb = new HSSFWorkbook( fin );
        fin.close();
        HSSFSheet s = wb.getSheetAt( 0 );
  HSSFFooter foot = s.getFooter();


  assertEquals("Bottom Left", foot.getLeft());
  assertEquals("Bottom Center", foot.getCenter());
  assertEquals("Bottom Right", foot.getRight());
    }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFooter

   * Testcase for Bug 17039 HSSFFooter doesnot support DBCS 
   */
   public void testFooterHas16bitCharacter() throws Exception{
      HSSFWorkbook b = new HSSFWorkbook();
      HSSFSheet s = b.createSheet("Test");
      HSSFFooter f = s.getFooter();
      f.setLeft("\u0391");
      f.setCenter("\u0392");
      f.setRight("\u0393");
      
      ByteArrayOutputStream out = new ByteArrayOutputStream();
      b.write(out);
      
      HSSFWorkbook b2 = new HSSFWorkbook(new ByteArrayInputStream(out.toByteArray()));
      HSSFFooter f2 = b2.getSheet("Test").getFooter();
      
      assertEquals(f2.getLeft(),"\u0391");
      assertEquals(f2.getCenter(),"\u0392");
      assertEquals(f2.getRight(),"\u0393");
  }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFooter

        HSSFHeader h = s.getHeader();
        assertEquals("Header Left " ,h.getLeft(),"\u090f\u0915");
        assertEquals("Header Center " ,h.getCenter(),"\u0939\u094b\u0917\u093e");
        assertEquals("Header Right " ,h.getRight(),"\u091c\u093e");
    
        HSSFFooter f = s.getFooter();
        assertEquals("Footer Left " ,f.getLeft(),"\u091c\u093e");
        assertEquals("Footer Center " ,f.getCenter(),"\u091c\u093e");
        assertEquals("Footer Right " ,f.getRight(),"\u091c\u093e");
  }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFooter

        filename = filename + "/EmbeddedChartHeaderTest.xls";
        FileInputStream fin = new FileInputStream( filename );
        HSSFWorkbook wb = new HSSFWorkbook( fin );
        fin.close();
        HSSFSheet s = wb.getSheetAt( 0 );
  HSSFFooter foot = s.getFooter();


  assertEquals("Bottom Left", foot.getLeft());
  assertEquals("Bottom Center", foot.getCenter());
  assertEquals("Bottom Right", foot.getRight());
    }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFooter

   * Testcase for Bug 17039 HSSFFooter doesnot support DBCS 
   */
   public void testFooterHas16bitCharacter() throws Exception{
      HSSFWorkbook b = new HSSFWorkbook();
      HSSFSheet s = b.createSheet("Test");
      HSSFFooter f = s.getFooter();
      f.setLeft("\u0391");
      f.setCenter("\u0392");
      f.setRight("\u0393");
      
      ByteArrayOutputStream out = new ByteArrayOutputStream();
      b.write(out);
      
      HSSFWorkbook b2 = new HSSFWorkbook(new ByteArrayInputStream(out.toByteArray()));
      HSSFFooter f2 = b2.getSheet("Test").getFooter();
      
      assertEquals(f2.getLeft(),"\u0391");
      assertEquals(f2.getCenter(),"\u0392");
      assertEquals(f2.getRight(),"\u0393");
  }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFooter

        HSSFHeader h = s.getHeader();
        assertEquals("Header Left " ,h.getLeft(),"\u090f\u0915");
        assertEquals("Header Center " ,h.getCenter(),"\u0939\u094b\u0917\u093e");
        assertEquals("Header Right " ,h.getRight(),"\u091c\u093e");
    
        HSSFFooter f = s.getFooter();
        assertEquals("Footer Left " ,f.getLeft(),"\u091c\u093e");
        assertEquals("Footer Center " ,f.getCenter(),"\u091c\u093e");
        assertEquals("Footer Right " ,f.getRight(),"\u091c\u093e");
  }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFooter

                    emptyCell.setCellStyle(emptyCellStyle);
                }
            }
        }
        HSSFHeader xlsHeader = xlsSheet.getHeader();
        HSSFFooter xlsFooter = xlsSheet.getFooter();


        if (StringUtil.stNul(leftHeader) != null) {
            xlsHeader.setLeft(StringUtil.stNul(leftHeader));
        }
        if (StringUtil.stNul(centerHeader) != null) {
            xlsHeader.setCenter(leftHeader);
            try {
                if (centerHeader.length() >= 254) {
                    centerHeader = centerHeader.substring(0, 254);
                }
                xlsHeader.setCenter(centerHeader);
            } catch (Exception e) {
                logger.log(Level.INFO, "Header string is too large.");
            }


        }
        if (StringUtil.stNul(rightHeader) != null) {
            xlsHeader.setRight(StringUtil.stNul(rightHeader));
        }
        if (StringUtil.stNul(leftFooter) != null) {
            xlsFooter.setLeft(StringUtil.stNul(leftFooter));
        }
        if (StringUtil.stNul(centerFooter) != null) {
            xlsFooter.setCenter(StringUtil.stNul(centerFooter));
        }
        if (StringUtil.stNul(rightFooter) != null) {
            xlsFooter.setRight(StringUtil.stNul(rightFooter));
        }


        /**
         * Print setup
         */

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFFooter

    
    /**
     * Set text to be printed at the bottom of every page
     */
    void setFooter(String left, String middle, String right) {
        HSSFFooter footer = _sheet.getFooter();
        footer.setLeft(left);
        footer.setCenter(middle);
        footer.setRight(right);
    }

View Full Code Here

0 1

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.