Examples of org.apache.poi.hssf.record.BOFRecord

org.apache.poi.hssf.record.BOFRecord
Title: Beginning Of File
Description: Somewhat of a misnomer, its used for the beginning of a set of records that have a particular pupose or subject. Used in sheets and workbooks.
REFERENCE: PG 289 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
@author Andrew C. Oliver @author Jason Height (jheight at chariot dot net dot au) @version 2.0-pre

        int dimsloc = -1;


        if (rs.peekNextSid() != BOFRecord.sid) {
            throw new RuntimeException("BOF record expected");
        }
        BOFRecord bof = (BOFRecord) rs.getNext();
        if (bof.getType() != BOFRecord.TYPE_WORKSHEET) {
            // TODO - fix junit tests throw new RuntimeException("Bad BOF record type");
        }
        records.add(bof);
        while (rs.hasNext()) {
            int recSid = rs.peekNextSid();

View Full Code Here


    /**
     * creates the BOF record
     */
    /* package */ static BOFRecord createBOF() {
        BOFRecord retval = new BOFRecord();


        retval.setVersion(( short ) 0x600);
        retval.setType(( short ) 0x010);


        retval.setBuild(( short ) 0x0dbb);
        retval.setBuildYear(( short ) 1996);
        retval.setHistoryBitMask(0xc1);
        retval.setRequiredVersion(0x6);
        return retval;
    }

View Full Code Here

    assertEquals(2, lt.getNumNames());
  }


    public void testAddNameX(){
        WorkbookRecordList wrl = new WorkbookRecordList();
        wrl.add(0, new BOFRecord());
        wrl.add(1, new CountryRecord());
        wrl.add(2, EOFRecord.instance);


        int numberOfSheets = 3;
        LinkTable tbl = new LinkTable(numberOfSheets, wrl);

View Full Code Here

           case BoundSheetRecord.sid:
               BoundSheetRecord sr = (BoundSheetRecord)record;
               sheetNames.add(sr.getSheetname());
               break;
           case BOFRecord.sid:
               BOFRecord bof = (BOFRecord)record;
               if(bof.getType() == BOFRecord.TYPE_WORKSHEET) {
                   sheetNum++;
                   rowNum = -1;


                   if(_includeSheetNames) {
                       if(_text.length() > 0) _text.append("\n");

View Full Code Here

        LastCellOfRowDummyRecord lc = (LastCellOfRowDummyRecord)record;
        log("Got end-of row, row was " + lc.getRow() + ", last column was " + lc.getLastColumnNumber());
      }
      
      if(record instanceof BOFRecord) {
        BOFRecord r = (BOFRecord)record;
        if(r.getType() == BOFRecord.TYPE_WORKSHEET) {
          log("On new sheet");
        }
      }
      if(record instanceof RowRecord) {
        RowRecord rr = (RowRecord)record;

View Full Code Here


      switch (record.getSid()) {
        // the BOFRecord can represent either the beginning of a sheet or
        // the workbook
        case BOFRecord.sid:
          BOFRecord bof = (BOFRecord) record;
          if (bof.getType() == BOFRecord.TYPE_WORKBOOK || 
                  bof.getType() == BOFRecord.TYPE_WORKSHEET) {
            // Reset the row and column counts - new workbook / worksheet
            resetCounts();
          }
          break;
        case RowRecord.sid:

View Full Code Here


        return retval;
    }


    private static BOFRecord createBOF() {
        BOFRecord retval = new BOFRecord();


        retval.setVersion(( short ) 0x600);
        retval.setType(BOFRecord.TYPE_WORKBOOK);
        retval.setBuild(( short ) 0x10d3);
        retval.setBuildYear(( short ) 1996);
        retval.setHistoryBitMask(0x41);   // was c1 before verify
        retval.setRequiredVersion(0x6);
        return retval;
    }

View Full Code Here

        }


        private void internalProcessRecord(Record record) throws SAXException, TikaException, IOException {
            switch (record.getSid()) {
            case BOFRecord.sid: // start of workbook, worksheet etc. records
                BOFRecord bof = (BOFRecord) record;
                if (bof.getType() == BOFRecord.TYPE_WORKBOOK) {
                    currentSheetIndex = -1;
                } else if (bof.getType() == BOFRecord.TYPE_CHART) {
                    if(previousSid == EOFRecord.sid) {
                        // This is a sheet which contains only a chart
                        newSheet();
                    } else {
                        // This is a chart within a normal sheet
                        // Handling of this is a bit hacky...
                        if (currentSheet != null) {
                            processSheet();
                            currentSheetIndex--;
                            newSheet();
                        }
                    }
                } else if (bof.getType() == BOFRecord.TYPE_WORKSHEET) {
                    newSheet();
                }
                break;


            case EOFRecord.sid: // end of workbook, worksheet etc. records

View Full Code Here

        }


        private void internalProcessRecord(Record record) throws SAXException, TikaException, IOException {
            switch (record.getSid()) {
            case BOFRecord.sid: // start of workbook, worksheet etc. records
                BOFRecord bof = (BOFRecord) record;
                if (bof.getType() == BOFRecord.TYPE_WORKBOOK) {
                    currentSheetIndex = -1;
                } else if (bof.getType() == BOFRecord.TYPE_CHART) {
                    if(previousSid == EOFRecord.sid) {
                        // This is a sheet which contains only a chart
                        newSheet();
                    } else {
                        // This is a chart within a normal sheet
                        // Handling of this is a bit hacky...
                        if (currentSheet != null) {
                            processSheet();
                            currentSheetIndex--;
                            newSheet();
                        }
                    }
                } else if (bof.getType() == BOFRecord.TYPE_WORKSHEET) {
                    newSheet();
                }
                break;


            case EOFRecord.sid: // end of workbook, worksheet etc. records

View Full Code Here

    
    switch (record.getSid())
        {
            // the BOFRecord can represent either the beginning of a sheet or the workbook
            case BOFRecord.sid:
                BOFRecord bof = (BOFRecord) record;
                if (bof.getType() == bof.TYPE_WORKBOOK)
                {
                  // Reset the row and column counts - new workbook
                  lastSeenRow = -1;
                  lastSeenColumn = -1;
                    //System.out.println("Encountered workbook");
                } else if (bof.getType() == bof.TYPE_WORKSHEET)
                {
                  // Reset the row and column counts - new sheet
                  lastSeenRow = -1;
                  lastSeenColumn = -1;
                    //System.out.println("Encountered sheet reference");

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.poi.hssf.record.BOFRecord

com.common.platform.excel.parser.HSSFParser

org.apache.poi.hssf.eventmodel.ModelFactory

org.apache.poi.hssf.eventmodel.TestEventRecordFactory

org.apache.poi.hssf.eventusermodel.examples.XLS2CSVmra

org.apache.poi.hssf.eventusermodel.MissingRecordAwareHSSFListener

org.apache.poi.hssf.eventusermodel.TestMissingRecordAwareHSSFListener$MockHSSFListener

org.apache.poi.hssf.extractor.EventBasedExcelExtractor$TextListener

org.apache.poi.hssf.model.InternalSheet

org.apache.poi.hssf.model.InternalWorkbook

org.apache.poi.hssf.model.Sheet

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.