FileDocCategorySizeDatePackage
Outlines.javaAPI DocApache Poi 3.0.110223Mon Jan 01 12:39:42 GMT 2007org.apache.poi.hssf.usermodel.examples

Outlines

public class Outlines extends Object
Creates outlines.
author
Glen Stampoultzis (glens at apache.org)

Fields Summary
Constructors Summary
private Outlines()

Methods Summary
private static voidcreateCase1(java.lang.String filename)

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

        FileOutputStream fileOut = new FileOutputStream(filename);
        wb.write(fileOut);
        fileOut.close();
    
private static voidcreateCase10(java.lang.String filename)

        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();
    
private static voidcreateCase11(java.lang.String filename)

        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();
    
private static voidcreateCase12(java.lang.String filename)

        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();
    
private static voidcreateCase13(java.lang.String filename)

        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet sheet1 = wb.createSheet("new sheet");

        sheet1.groupRow( 5, 14 );
        sheet1.groupRow( 7, 14 );
        sheet1.groupRow( 16, 19 );

        sheet1.groupColumn( (short)4, (short)7 );
        sheet1.groupColumn( (short)9, (short)12 );
        sheet1.groupColumn( (short)10, (short)11 );

        FileOutputStream fileOut = new FileOutputStream(filename);
        wb.write(fileOut);
        fileOut.close();
    
private static voidcreateCase2(java.lang.String filename)

        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();
    
private static voidcreateCase3(java.lang.String filename)

        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();
    
private static voidcreateCase4(java.lang.String filename)

        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();
    
private static voidcreateCase5(java.lang.String filename)

        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();
    
private static voidcreateCase6(java.lang.String filename)

        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();
    
private static voidcreateCase7(java.lang.String filename)

        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();
    
private static voidcreateCase8(java.lang.String filename)

        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();
    
private static voidcreateCase9(java.lang.String filename)

        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();
    
public static voidmain(java.lang.String[] args)

        createCase1( "outline1.xls" );
        System.out.println( "outline1.xls written.  Two expanded groups." );
        createCase2( "outline2.xls" );
        System.out.println( "outline2.xls written.  Two groups.  Inner group collapsed." );
        createCase3( "outline3.xls" );
        System.out.println( "outline3.xls written.  Two groups.  Both collapsed." );
        createCase4( "outline4.xls" );
        System.out.println( "outline4.xls written.  Two groups.  Collapsed then inner group expanded." );
        createCase5( "outline5.xls" );
        System.out.println( "outline5.xls written.  Two groups.  Collapsed then reexpanded." );
        createCase6( "outline6.xls" );
        System.out.println( "outline6.xls written.  Two groups with matching end points.  Second group collapsed." );
        createCase7( "outline7.xls" );
        System.out.println( "outline7.xls written.  Row outlines." );
        createCase8( "outline8.xls" );
        System.out.println( "outline8.xls written.  Row outlines.  Inner group collapsed." );
        createCase9( "outline9.xls" );
        System.out.println( "outline9.xls written.  Row outlines.  Both collapsed." );
        createCase10( "outline10.xls" );
        System.out.println( "outline10.xls written.  Row outlines.  Collapsed then inner group expanded." );
        createCase11( "outline11.xls" );
        System.out.println( "outline11.xls written.  Row outlines.  Collapsed then expanded." );
        createCase12( "outline12.xls" );
        System.out.println( "outline12.xls written.  Row outlines.  Two row groups with matching end points.  Second group collapsed." );
        createCase13( "outline13.xls" );
        System.out.println( "outline13.xls written.  Mixed bag." );