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

org.apache.poi.hssf.usermodel.HSSFWorkbook
High level representation of a workbook. This is the first object most users will construct whether they are reading or writing a workbook. It is also the top level object for creating new sheets/etc. @see org.apache.poi.hssf.model.Workbook @see org.apache.poi.hssf.usermodel.HSSFSheet @author Andrew C. Oliver (acoliver at apache dot org) @author Glen Stampoultzis (glens at apache.org) @author Shawn Laubach (slaubach at apache dot org) @version 2.0-pre

            assertTrue("DividePtg",(ptgs[2] instanceof DividePtg));
  }
  
  /** bug 35027, underscore in sheet name*/
  public void testUnderscore() {
    HSSFWorkbook wb = new HSSFWorkbook();
      
      wb.createSheet("Cash_Flow");;
      
      HSSFSheet sheet = wb.createSheet("Test");
      HSSFRow row = sheet.createRow(0);
      HSSFCell cell;
      
      cell = row.createCell((short)0);
      cell.setCellFormula("Cash_Flow!A1");

View Full Code Here

    /**
     * Tests reading a file containing this ptg.
     */
    public void testReading() throws Exception
    {
        HSSFWorkbook workbook = loadWorkbook("IntersectionPtg.xls");
        HSSFCell cell = workbook.getSheetAt(0).getRow(4).getCell((short) 2);
        assertEquals("Wrong cell value", 5.0, cell.getNumericCellValue(), 0.0);
        assertEquals("Wrong cell formula", "SUM(A1:B2 B2:C3)", cell.getCellFormula());
    }

View Full Code Here

    protected void setUp() throws Exception
    {
        super.setUp();
        models = new ArrayList(3);
        factory = new ModelFactory();
        book = new HSSFWorkbook();
        ByteArrayOutputStream stream = (ByteArrayOutputStream)setupRunFile(book);    
        POIFSFileSystem fs = new POIFSFileSystem(
                                   new ByteArrayInputStream(stream.toByteArray())
                                   );
        in = fs.createDocumentInputStream("Workbook");

View Full Code Here

    assertEquals("TOTAL[", firstString.getValue());
    //the PTG order isn't 100% correct but it still works - dmui
  }


  public void testMacroFunction() {
    HSSFWorkbook w = new HSSFWorkbook();
    Ptg[] ptg = FormulaParser.parse("FOO()", w);


    // the name gets encoded as the first arg
    NamePtg tname = (NamePtg) ptg[0];
    assertEquals("FOO", tname.toFormulaString(w));

View Full Code Here

    assertTrue("first ptg is string", ptgs[0] instanceof StringPtg);
    assertTrue("second ptg is string", ptgs[1] instanceof StringPtg);
  }


  public void testWorksheetReferences() {
    HSSFWorkbook wb = new HSSFWorkbook();


    wb.createSheet("NoQuotesNeeded");
    wb.createSheet("Quotes Needed Here &#$@");


    HSSFSheet sheet = wb.createSheet("Test");
    HSSFRow row = sheet.createRow(0);
    HSSFCell cell;


    cell = row.createCell((short)0);
    cell.setCellFormula("NoQuotesNeeded!A1");

View Full Code Here

    assertTrue("DividePtg", (ptgs[2] instanceof DividePtg));
  }


  /** bug 35027, underscore in sheet name */
  public void testUnderscore() {
    HSSFWorkbook wb = new HSSFWorkbook();


    wb.createSheet("Cash_Flow");


    HSSFSheet sheet = wb.createSheet("Test");
    HSSFRow row = sheet.createRow(0);
    HSSFCell cell;


    cell = row.createCell((short)0);
    cell.setCellFormula("Cash_Flow!A1");

View Full Code Here

    assertTrue("IntPtg", (ptgs[1] instanceof IntPtg));
    assertTrue("DividePtg", (ptgs[2] instanceof DividePtg));
  }


  public void testExponentialInSheet() {
    HSSFWorkbook wb = new HSSFWorkbook();


    wb.createSheet("Cash_Flow");


    HSSFSheet sheet = wb.createSheet("Test");
    HSSFRow row = sheet.createRow(0);
    HSSFCell cell = row.createCell((short)0);
    String formula = null;


    cell.setCellFormula("1.3E21/3");

View Full Code Here

    formula = cell.getCellFormula();
    assertEquals("Exponential formula string", "-1.0/310.0*4000.0/30000.0", formula);
  }


  public void testNumbers() {
    HSSFWorkbook wb = new HSSFWorkbook();


    wb.createSheet("Cash_Flow");


    HSSFSheet sheet = wb.createSheet("Test");
    HSSFRow row = sheet.createRow(0);
    HSSFCell cell = row.createCell((short)0);
    String formula = null;


    // starts from decimal point

View Full Code Here

    formula = cell.getCellFormula();
    assertEquals("1.0", formula);
  }


  public void testRanges() {
    HSSFWorkbook wb = new HSSFWorkbook();


    wb.createSheet("Cash_Flow");


    HSSFSheet sheet = wb.createSheet("Test");
    HSSFRow row = sheet.createRow(0);
    HSSFCell cell = row.createCell((short)0);
    String formula = null;


    cell.setCellFormula("A1.A2");

View Full Code Here

  /**
   * Test for bug observable at svn revision 618865 (5-Feb-2008)<br/>
   * a formula consisting of a single no-arg function got rendered without the function braces
   */
  public void testToFormulaStringZeroArgFunction() {
    HSSFWorkbook book = new HSSFWorkbook();


    Ptg[] ptgs = {
        new FuncPtg(10),
    };
    assertEquals("NA()", FormulaParser.toFormulaString(book, ptgs));

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.poi.hssf.usermodel.HSSFWorkbook

bad.robot.excel.DateCellTest

bad.robot.excel.matchers.StubCell

bg.smoc.web.servlet.ResultsServlet

com.asakusafw.testdriver.excel.Util

com.canoo.ant.table.ExcelPropertyTable

com.canoo.webtest.plugins.exceltest.AbstractExcelStep

com.dtrules.compiler.excel.util.ImportRuleSets

com.dtrules.compiler.excel.util.Rules2Excel

com.google.refine.importers.ExcelImporter

com.jfinal.ext.interceptor.excel.ExcelExporter

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.