Examples of org.apache.poi.hssf.model.Sheet

org.apache.poi.hssf.model.Sheet
enoffice.org/excelfileformat.pdf before even attempting to use this.
@author Andrew C. Oliver (acoliver at apache dot org) @author Glen Stampoultzis (glens at apache.org) @author Shawn Laubach (slaubach at apache dot org) Gridlines, Headers, Footers, PrintSetup, and Setting Default Column Styles @author Jason Height (jheight at chariot dot net dot au) Clone support. DBCell & Index Record writing support @author Brian Sanders (kestrel at burdell dot org) Active Cell support @author Jean-Pierre Paris (jean-pierre.paris at m4x dot org) (Just a little) @see org.apache.poi.hssf.model.Workbook @see org.apache.poi.hssf.usermodel.HSSFSheet @version 1.0-pre

              switch (bof.getType()) {
               case BOFRecord.TYPE_WORKBOOK:
                 currentmodel = new Workbook();                 
               break;
               case BOFRecord.TYPE_WORKSHEET:
                 currentmodel = new Sheet();                                  
               break;
              default:
                   throw new RuntimeException("Unsupported model type "+bof.getType());
              }

View Full Code Here

        //read in sample
        HSSFWorkbook book = openSample("Simple.xls");
        
        //check initial position
        HSSFSheet umSheet = book.getSheetAt(0);
        Sheet s = umSheet.getSheet();
        assertEquals("Initial active cell should be in col 0",
            (short) 0, s.getActiveCellCol());
        assertEquals("Initial active cell should be on row 1",
            1, s.getActiveCellRow());
        
        //modify position through HSSFCell
        HSSFCell cell = umSheet.createRow(3).createCell((short) 2);
        cell.setAsActiveCell();
        assertEquals("After modify, active cell should be in col 2",
            (short) 2, s.getActiveCellCol());
        assertEquals("After modify, active cell should be on row 3",
            3, s.getActiveCellRow());
        
        //write book to temp file; read and verify that position is serialized
        book = writeOutAndReadBack(book);


        umSheet = book.getSheetAt(0);
        s = umSheet.getSheet();
        
        assertEquals("After serialize, active cell should be in col 2",
            (short) 2, s.getActiveCellCol());
        assertEquals("After serialize, active cell should be on row 3",
            3, s.getActiveCellRow());
    }

View Full Code Here

       HSSFWorkbook wb = new HSSFWorkbook();
       
       for (int i=0; i < 10; i++)
       {
      HSSFSheet s = wb.createSheet("Sheet " +i);
      Sheet sheet = s.getSheet();
       }


     wb.getWorkbook().setSheetOrder("Sheet 6", 0);
    wb.getWorkbook().setSheetOrder("Sheet 3", 7);
    wb.getWorkbook().setSheetOrder("Sheet 1", 9);

View Full Code Here

  public void testBackupRecord()
      throws Exception
  {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet s = wb.createSheet();
    Sheet sheet = s.getSheet();


    assertEquals(true, sheet.getGridsetRecord().getGridset());
    s.setGridsPrinted(true);
    assertEquals(false, sheet.getGridsetRecord().getGridset());
  }

View Full Code Here

  public void testVerticallyCenter()
      throws Exception
  {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet s = wb.createSheet();
    Sheet sheet = s.getSheet();
    VCenterRecord record =
        (VCenterRecord) sheet.findFirstRecordBySid(VCenterRecord.sid);


    assertEquals(false, record.getVCenter());
    s.setVerticallyCenter(true);
    assertEquals(true, record.getVCenter());

View Full Code Here

  public void testHorizontallyCenter()
      throws Exception
  {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet s = wb.createSheet();
    Sheet sheet = s.getSheet();
    HCenterRecord record =
        (HCenterRecord) sheet.findFirstRecordBySid(HCenterRecord.sid);


    assertEquals(false, record.getHCenter());
    s.setHorizontallyCenter(true);
    assertEquals(true, record.getHCenter());

View Full Code Here


  public void testWSBool()
  {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet s = wb.createSheet();
    Sheet sheet = s.getSheet();
    WSBoolRecord record =
        (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid);


    // Check defaults
    assertEquals(true, record.getAlternateExpression());
    assertEquals(true, record.getAlternateFormula());
    assertEquals(false, record.getAutobreaks());

View Full Code Here

   * Test that the ProtectRecord is included when creating or cloning a sheet
   */
  public void testProtect() {
    HSSFWorkbook workbook = new HSSFWorkbook();
    HSSFSheet hssfSheet = workbook.createSheet();
    Sheet sheet = hssfSheet.getSheet();
    ProtectRecord protect = sheet.getProtect();
   
    assertFalse(protect.getProtect());


    // This will tell us that cloneSheet, and by extension,
    // the list forms of createSheet leave us with an accessible
    // ProtectRecord.
    hssfSheet.setProtect(true);
    Sheet cloned = sheet.cloneSheet();
    assertNotNull(cloned.getProtect());
    assertTrue(hssfSheet.getProtect());
  }

View Full Code Here

  public void testProtectSheet() {
    short expected = (short)0xfef1;
  HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet s = wb.createSheet();
    s.protectSheet("abcdefghij");
    Sheet sheet = s.getSheet();
  ProtectRecord protect = sheet.getProtect();
  PasswordRecord pass = sheet.getPassword();
    assertTrue("protection should be on",protect.getProtect());
    assertTrue("object protection should be on",sheet.isProtected()[1]);
    assertTrue("scenario protection should be on",sheet.isProtected()[2]);
    assertEquals("well known value for top secret hash should be "+Integer.toHexString(expected).substring(4),expected,pass.getPassword());
  }

View Full Code Here

        HSSFWorkbook wb = new HSSFWorkbook();
        
        for (int i=0; i < 10; i++)
        {
      HSSFSheet s = wb.createSheet("Sheet " + i);
      Sheet sheet = s.getSheet();
        }
        
        // Check the initial order
        assertEquals(0, wb.getSheetIndex("Sheet 0"));
        assertEquals(1, wb.getSheetIndex("Sheet 1"));

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.poi.hssf.model.Sheet

org.apache.poi.hssf.eventmodel.ModelFactory

org.apache.poi.hssf.record.aggregates.CFRecordsAggregate

org.apache.poi.hssf.record.aggregates.ChartSubstreamRecordAggregate

org.apache.poi.hssf.record.aggregates.ColumnInfoRecordsAggregate

org.apache.poi.hssf.record.aggregates.ConditionalFormattingTable

org.apache.poi.hssf.record.aggregates.CustomViewSettingsRecordAggregate

org.apache.poi.hssf.record.aggregates.DataValidityTable

org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate

org.apache.poi.hssf.record.aggregates.MergedCellsTable

org.apache.poi.hssf.record.aggregates.PageSettingsBlock

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.