Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet()

Class org.apache.poi.hssf.usermodel.HSSFWorkbook

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet()

org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet()
create an HSSFSheet for this HSSFWorkbook, adds it to the sheets and returns the high level representation. Use this to create new sheets. @return HSSFSheet representing the new sheet.


        Workbook wb = new HSSFWorkbook();


        FormulaEvaluator fe = wb.getCreationHelper().createFormulaEvaluator();


        Sheet sh = wb.createSheet();
        Cell a1 = sh.createRow(0).createCell(0);
        a1.setCellValue(1);
        Cell a2 = sh.createRow(1).createCell(0);
        a2.setCellValue(3);
        Cell a3 = sh.createRow(2).createCell(0);

View Full Code Here


        Workbook wb = new HSSFWorkbook();


        FormulaEvaluator fe = wb.getCreationHelper().createFormulaEvaluator();


        Sheet sh = wb.createSheet();
        Cell a1 = sh.createRow(0).createCell(0);
        a1.setCellValue(1);
        Cell a2 = sh.createRow(1).createCell(0);
        a2.setCellValue(3);
        Cell a3 = sh.createRow(2).createCell(0);

View Full Code Here


        Workbook wb = new HSSFWorkbook();


        FormulaEvaluator fe = wb.getCreationHelper().createFormulaEvaluator();


        Sheet sh = wb.createSheet();
        Cell a1 = sh.createRow(0).createCell(0);
        a1.setCellValue(1);
        Cell a2 = sh.createRow(1).createCell(0);
        a2.setCellValue(3);
        Cell a3 = sh.createRow(2).createCell(0);

View Full Code Here

        assertEquals(2.82842, a7.getNumericCellValue(), 0.0001);
    }


    public void test50209(){
        Workbook wb = new HSSFWorkbook();
        Sheet sh = wb.createSheet();
        Cell a1 = sh.createRow(0).createCell(0);
        a1.setCellValue(1);
        Cell a2 = sh.createRow(1).createCell(0);
        a2.setCellFormula("SUBTOTAL(9,A1)");
        Cell a3 = sh.createRow(2).createCell(0);

View Full Code Here

  /**
   * In 3.1, setting margins between creating first row and first cell caused an exception.
   */
  public void testSetMargins_bug45717() {
    HSSFWorkbook workbook = new HSSFWorkbook();
    HSSFSheet sheet = workbook.createSheet("Vorschauliste");
    HSSFRow row = sheet.createRow(0);


    sheet.setMargin(HSSFSheet.LeftMargin, 0.3);
    try {
      row.createCell(0);

View Full Code Here

    public void testErrors() {
        DataFormatter dfUS = new DataFormatter(Locale.US, true);


        // Create a spreadsheet with some formula errors in it
        Workbook wb = new HSSFWorkbook();
        Sheet s = wb.createSheet();
        Row r = s.createRow(0);
        Cell c = r.createCell(0, Cell.CELL_TYPE_ERROR);
        
        c.setCellErrorValue(FormulaError.DIV0.getCode());
        assertEquals(FormulaError.DIV0.getString(), dfUS.formatCellValue(c));

View Full Code Here

        assertTrue(fontFormatting.isUnderlineTypeModified());
    }


    public void testWrite() {
        HSSFWorkbook workbook = new HSSFWorkbook();
        HSSFSheet sheet = workbook.createSheet();
        CFRuleRecord rr = CFRuleRecord.create(sheet, ComparisonOperator.BETWEEN, "5", "10");


        PatternFormatting patternFormatting = new PatternFormatting();
        patternFormatting.setFillPattern(PatternFormatting.BRICKS);
        rr.setPatternFormatting(patternFormatting);

View Full Code Here

        TestcaseRecordInputStream.confirmRecordEncoding(CFRuleRecord.sid, DATA_REFN, data);
    }
    
    public void testBug53691() {
        HSSFWorkbook workbook = new HSSFWorkbook();
        HSSFSheet sheet = workbook.createSheet();


        CFRuleRecord record = CFRuleRecord.create(sheet, ComparisonOperator.BETWEEN, "2", "5");
        
        CFRuleRecord clone = (CFRuleRecord) record.clone();

View Full Code Here

    public HSSFWorkbook getStubHSSFWorkbook() {
        // Create a base workbook
        HSSFWorkbook wb = HSSFWorkbook.create(getStubWorkbook());
        // Stub the sheets, so sheet name lookups work
        for (BoundSheetRecord bsr : boundSheetRecords) {
            wb.createSheet(bsr.getSheetname());
        }
        // Ready for Formula use!
        return wb;
    }
    public InternalWorkbook getStubWorkbook() {

View Full Code Here

    }
  }


  public void testRangeUsingOffsetFunc_bug46948() {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFRow row = wb.createSheet("Sheet1").createRow(0);
    HSSFCell cellA1 = row.createCell(0);
    HSSFCell cellB1 = row.createCell(1);
    row.createCell(2).setCellValue(5.0); // C1
    row.createCell(3).setCellValue(7.0); // D1
    row.createCell(4).setCellValue(9.0); // E1

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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.