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)

        fileOut.close();
    }


    private static void createCase6( 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)10 );
        sheet1.setColumnGroupCollapsed( (short)4, true );
        sheet1.setColumnGroupCollapsed( (short)2, true );


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


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

View Full Code Here


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


        sheet1.groupRow( 5, 14 );
        sheet1.groupRow( 7, 10 );


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

View Full Code Here


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


        sheet1.groupRow( 5, 14 );
        sheet1.groupRow( 7, 10 );
        sheet1.setRowGroupCollapsed( 7, true );


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

View Full Code Here


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


        sheet1.groupRow( 5, 14 );
        sheet1.groupRow( 7, 10 );
        sheet1.setRowGroupCollapsed( 7, true );
        sheet1.setRowGroupCollapsed( 5, true );


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

View Full Code Here


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


        sheet1.groupRow( 5, 14 );
        sheet1.groupRow( 7, 10 );
        sheet1.setRowGroupCollapsed( 7, true );
        sheet1.setRowGroupCollapsed( 5, true );
        sheet1.setRowGroupCollapsed( 8, false );


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

View Full Code Here


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


        sheet1.groupRow( 5, 14 );
        sheet1.groupRow( 7, 10 );
        sheet1.setRowGroupCollapsed( 7, true );
        sheet1.setRowGroupCollapsed( 5, true );
        sheet1.setRowGroupCollapsed( 8, false );
        sheet1.setRowGroupCollapsed( 14, false );


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

View Full Code Here


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


        sheet1.groupRow( 5, 14 );
        sheet1.groupRow( 7, 14 );
        sheet1.setRowGroupCollapsed( 7, true );
        sheet1.setRowGroupCollapsed( 5, true );
        sheet1.setRowGroupCollapsed( 6, false );


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

View Full Code Here

{
    public static void main(String[] args)
        throws IOException
    {
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet sheet1 = wb.createSheet("new sheet");
        HSSFSheet sheet2 = wb.createSheet("second sheet");
        FileOutputStream fileOut = new FileOutputStream("workbook.xls");
        wb.write(fileOut);
        fileOut.close();
    }

View Full Code Here

{
    public static void main(String[] args)
        throws IOException
    {
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet sheet = wb.createSheet("new sheet");
        HSSFRow row = sheet.createRow((short)2);
        row.createCell((short) 0).setCellValue(1.1);
        row.createCell((short) 1).setCellValue(new Date());
        row.createCell((short) 2).setCellValue("a string");
        row.createCell((short) 3).setCellValue(true);
        row.createCell((short) 4).setCellType(HSSFCell.CELL_TYPE_ERROR);

View Full Code Here

    
    public void setUp() {
    }
    
    public void genericTest() throws Exception {
        HSSFSheet s = workbook.getSheetAt( 0 );
        HSSFRow r = s.getRow(getBeginRow());
        short endcolnum = r.getLastCellNum();
        HSSFFormulaEvaluator evaluator = new HSSFFormulaEvaluator(s, workbook);
        evaluator.setCurrentRow(r);


        HSSFCell c = null;

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.