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

org.apache.poi.hssf.usermodel.HSSFCell
High level representation of a cell in a row of a spreadsheet. Cells can be numeric, formula-based or string-based (text). The cell type specifies this. String cells cannot conatin numbers and numeric cells cannot contain strings (at least according to our model). Client apps should do the conversions themselves. Formula cells have the formula string, as well as the formula result, which can be numeric or string.
Cells should have their number (0 based) before being added to a row. Only cells that have values should be added.
@author Andrew C. Oliver (acoliver at apache dot org) @author Dan Sherman (dsherman at isisph.com) @author Brian Sanders (kestrel at burdell dot org) Active Cell support @author Yegor Kozlov cell comments support


    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


    cell.setCellFormula(".1");
    formula = cell.getCellFormula();
    assertEquals("0.1", formula);


    cell.setCellFormula("+.1");
    formula = cell.getCellFormula();
    assertEquals("+0.1", formula);


    cell.setCellFormula("-.1");
    formula = cell.getCellFormula();
    assertEquals("-0.1", formula);


    // has exponent


    cell.setCellFormula("10E1");
    formula = cell.getCellFormula();
    assertEquals("100.0", formula);


    cell.setCellFormula("10E+1");
    formula = cell.getCellFormula();
    assertEquals("100.0", formula);


    cell.setCellFormula("10E-1");
    formula = cell.getCellFormula();
    assertEquals("1.0", formula);
  }

View Full Code Here


    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");
    formula = cell.getCellFormula();
    assertEquals("A1:A2", formula);


    cell.setCellFormula("A1..A2");
    formula = cell.getCellFormula();
    assertEquals("A1:A2", formula);


    cell.setCellFormula("A1...A2");
    formula = cell.getCellFormula();
    assertEquals("A1:A2", formula);
  }

View Full Code Here

    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet();
    wb.setSheetName(0, "Sheet1");


    HSSFRow row = sheet.createRow(0);
    HSSFCell cell = row.createCell((short)0);
    cell.setCellFormula("right(\"test\"\"ing\", 3)");
    String actualCellFormula = cell.getCellFormula();
    if("RIGHT(\"test\"ing\",3)".equals(actualCellFormula)) {
      throw new AssertionFailedError("Identified bug 28754b");
    }
    assertEquals("RIGHT(\"test\"\"ing\",3)", actualCellFormula);
  }

View Full Code Here

    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet();
    wb.setSheetName(0, "Sheet1");


    HSSFRow row = sheet.createRow(0);
    HSSFCell cell = row.createCell((short)0);
    cell.setCellFormula("SUM(A32769:A32770)");
    if("SUM(A-32767:A-32766)".equals(cell.getCellFormula())) {
      fail("Identified bug 44539");
    }
    assertEquals("SUM(A32769:A32770)", cell.getCellFormula());
  }

View Full Code Here


  public void testInSpreadSheet() {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("Sheet1");
    HSSFRow row = sheet.createRow(0);
    HSSFCell cell = row.createCell((short)0);
    cell.setCellFormula("B1%");
    row.createCell((short)1).setCellValue(50.0);
    
    HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(sheet, wb);
    fe.setCurrentRow(row);
    CellValue cv;

View Full Code Here

  public int getColumnCount() {
    return this.maxcol+1;
  }
  public Object getValueAt(int row, int col) {
    HSSFRow r = st.getRow(row);
    HSSFCell c = null;
    if (r != null) {
      c = r.getCell((short)col);
    }
    return c;
  }

View Full Code Here

    int rowEnd = region.getRowTo();
    int column = region.getColumnFrom();


    for ( int i = rowStart; i <= rowEnd; i++ ) {
      HSSFRow row = HSSFCellUtil.getRow( i, sheet );
      HSSFCell cell = HSSFCellUtil.getCell( row, column );
      HSSFCellUtil.setCellStyleProperty( cell, workbook, "borderLeft", new Short( border ) );
    }
  }

View Full Code Here

    int rowEnd = region.getRowTo();
    int column = region.getColumnFrom();


    for ( int i = rowStart; i <= rowEnd; i++ ) {
      HSSFRow row = HSSFCellUtil.getRow( i, sheet );
      HSSFCell cell = HSSFCellUtil.getCell( row, column );
      HSSFCellUtil.setCellStyleProperty( cell, workbook, "leftBorderColor", new Short( color ) );
    }
  }

View Full Code Here

    int rowEnd = region.getRowTo();
    int column = region.getColumnTo();


    for ( int i = rowStart; i <= rowEnd; i++ ) {
      HSSFRow row = HSSFCellUtil.getRow( i, sheet );
      HSSFCell cell = HSSFCellUtil.getCell( row, column );


      HSSFCellUtil.setCellStyleProperty( cell, workbook, "borderRight", new Short( border ) );
    }
  }

View Full Code Here

    int rowEnd = region.getRowTo();
    int column = region.getColumnTo();


    for ( int i = rowStart; i <= rowEnd; i++ ) {
      HSSFRow row = HSSFCellUtil.getRow( i, sheet );
      HSSFCell cell = HSSFCellUtil.getCell( row, column );
      HSSFCellUtil.setCellStyleProperty( cell, workbook, "rightBorderColor", new Short( color ) );
    }
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

bg.smoc.web.servlet.ResultsServlet

br.net.woodstock.rockframework.office.spreadsheet.poi.HSSFSpreadsheetDocumentWriter

cn.baiweigang.qtaf.toolkit.dbunit.data.excel.XlsTable

com.aaspring.translation.XlsDoor

com.aesthete.swingobjects.fw.common.util.ExcelHelper

com.asakusafw.testtools.excel.ExcelUtils

com.asakusafw.testtools.excel.ExcelUtilsTest

com.asakusafw.testtools.templategen.ExcelBookBuilder

com.canoo.webtest.plugins.exceltest.ExcelVerifyCellStyle

com.canoo.webtest.plugins.exceltest.ExcelVerifyCellSum

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.