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

org.apache.poi.hssf.usermodel.HSSFSheet
High level representation of a worksheet. @author Andrew C. Oliver (acoliver at apache dot org) @author Glen Stampoultzis (glens at apache.org) @author Libin Roman (romal at vistaportal.com) @author Shawn Laubach (slaubach at apache dot org) (Just a little) @author Jean-Pierre Paris (jean-pierre.paris at m4x dot org) (Just a little, too) @author Yegor Kozlov (yegor at apache.org) (Autosizing columns)

  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");
    formula = cell.getCellFormula();

View Full Code Here

      throw e;
    }
    assertEquals("test\"ing", sp.getValue());


    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");

View Full Code Here

  }


  public void testSetFormulaWithRowBeyond32768_Bug44539() {


    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");
    }

View Full Code Here

    confirm(BoolEval.TRUE, 0.01);
  }


  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);

View Full Code Here

        try
        {
            fileIn = new FileInputStream("workbook.xls");
            POIFSFileSystem fs = new POIFSFileSystem(fileIn);
            HSSFWorkbook wb = new HSSFWorkbook(fs);
            HSSFSheet sheet = wb.getSheetAt(0);
            HSSFRow row = sheet.getRow(2);
            if (row == null)
                row = sheet.createRow(2);
            HSSFCell cell = row.getCell((short)3);
            if (cell == null)
                cell = row.createCell((short)3);
            cell.setCellType(HSSFCell.CELL_TYPE_STRING);
            cell.setCellValue("a test");

View Full Code Here

        System.out.println( "outline13.xls written.  Mixed bag." );
    }


    private static void createCase1( String filename ) throws IOException{
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet sheet1 = wb.createSheet("new sheet");


        sheet1.groupColumn( (short)4, (short)7 );


        for (int row = 0; row < 200; row++)
        {
            HSSFRow r = sheet1.createRow( row );
            for (int column = 0; column < 200; column++)
            {
                HSSFCell c = r.createCell( (short) column );
                c.setCellValue( column );
            }

View Full Code Here

        fileOut.close();
    }


    private static void createCase2( String filename ) throws IOException{
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet sheet1 = wb.createSheet("new sheet");


        sheet1.groupColumn( (short)2, (short)10 );
        sheet1.groupColumn( (short)4, (short)7 );
        sheet1.setColumnGroupCollapsed( (short)4, true );


        FileOutputStream fileOut = new FileOutputStream(filename);
        wb.write(fileOut);
        fileOut.close();
    }

View Full Code Here

        fileOut.close();
    }


    private static void createCase3( String filename ) throws IOException{
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet sheet1 = wb.createSheet("new sheet");


        sheet1.groupColumn( (short)2, (short)10 );
        sheet1.groupColumn( (short)4, (short)7 );
        sheet1.setColumnGroupCollapsed( (short)4, true );
        sheet1.setColumnGroupCollapsed( (short)2, true );


        FileOutputStream fileOut = new FileOutputStream(filename);
        wb.write(fileOut);
        fileOut.close();
    }

View Full Code Here

        fileOut.close();
    }


    private static void createCase4( String filename ) throws IOException{
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet sheet1 = wb.createSheet("new sheet");


        sheet1.groupColumn( (short)2, (short)10 );
        sheet1.groupColumn( (short)4, (short)7 );
        sheet1.setColumnGroupCollapsed( (short)4, true );
        sheet1.setColumnGroupCollapsed( (short)2, true );


        sheet1.setColumnGroupCollapsed( (short)4, false );


        FileOutputStream fileOut = new FileOutputStream(filename);
        wb.write(fileOut);
        fileOut.close();
    }

View Full Code Here

        fileOut.close();
    }


    private static void createCase5( String filename ) throws IOException{
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet sheet1 = wb.createSheet("new sheet");


        sheet1.groupColumn( (short)2, (short)10 );
        sheet1.groupColumn( (short)4, (short)7 );
        sheet1.setColumnGroupCollapsed( (short)4, true );
        sheet1.setColumnGroupCollapsed( (short)2, true );


        sheet1.setColumnGroupCollapsed( (short)4, false );
        sheet1.setColumnGroupCollapsed( (short)3, false );


        FileOutputStream fileOut = new FileOutputStream(filename);
        wb.write(fileOut);
        fileOut.close();
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

bad.robot.excel.DateCellTest

bg.smoc.web.servlet.ResultsServlet

com.asakusafw.testtools.templategen.ExcelBookBuilder

com.canoo.ant.table.ExcelPropertyTable

com.commander4j.util.JExcel

com.dtrules.compiler.excel.util.ImportRuleSets

com.jfinal.ext.interceptor.excel.ExcelExporter

com.vsked.test.TestExcel

com.vsked.util.FileOperate

er.excel.EGSimpleWorkbookHelper

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.