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

org.apache.poi.hssf.record.BlankRecord
Title: Blank cell record
Description: Represents a column in a row with no value but with styling.
REFERENCE: PG 287 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
@author Andrew C. Oliver (acoliver at apache dot org) @author Jason Height (jheight at chariot dot net dot au) @version 2.0-pre

            case SSTRecord.sid: // 待处理的记录
                sstRecord = (SSTRecord) record;
                break;


            case BlankRecord.sid: // 空白记录
                BlankRecord brec = (BlankRecord) record;


                thisRow = brec.getRow();
                thisColumn = brec.getColumn();
                if(blankCell){
                    rowList.add(index, " ");
                }
                break;
            case BoolErrRecord.sid: // 逻辑错误记录

View Full Code Here

        HSSFSheet sheet = workbook.createSheet("Sheet1");
        RowRecord rowRec = new RowRecord(ROW_IX);
        rowRec.setFirstCol((short)2);
        rowRec.setLastCol((short)5);


        BlankRecord br = new BlankRecord();
        br.setRow(ROW_IX);
    br.setColumn((short)COL_IX);


        sheet.getSheet().addValueRecord(ROW_IX, br);
        HSSFRow row = new HSSFRow(workbook, sheet, rowRec);
        HSSFCell cell = row.createCellFromRecord(br);

View Full Code Here

                }
                _record = lrec;
                break;


            case CELL_TYPE_BLANK :
                BlankRecord brec = null;


                if (cellType != _cellType)
                {
                    brec = new BlankRecord();
                }
                else
                {
                    brec = ( BlankRecord ) _record;
                }
                brec.setColumn(col);


                // During construction the cellStyle may be null for a Blank cell.
                brec.setXFIndex(styleIndex);
                brec.setRow(row);
                _record = brec;
                break;


            case CELL_TYPE_BOOLEAN :
                BoolErrRecord boolRec = null;

View Full Code Here

                (( LabelSSTRecord ) record).setRow(row);
                (( LabelSSTRecord ) record).setXFIndex(( short ) 0);
                break;


            case CELL_TYPE_BLANK :
                record = new BlankRecord();
                (( BlankRecord ) record).setColumn(col);
                (( BlankRecord ) record).setRow(row);
                (( BlankRecord ) record).setXFIndex(( short ) 0);
                break;

View Full Code Here

                }
                record = lrec;
                break;


            case CELL_TYPE_BLANK :
                BlankRecord brec = null;


                if (cellType != this.cellType)
                {
                    brec = new BlankRecord();
                }
                else
                {
                    brec = ( BlankRecord ) record;
                }
                brec.setColumn(getCellNum());


                // During construction the cellStyle may be null for a Blank cell.
                if (cellStyle != null)
                {
                    brec.setXFIndex(( short ) cellStyle.getIndex());
                }
                else
                {
                    brec.setXFIndex(( short ) 0);
                }
                brec.setRow(row);
                record = brec;
                break;


            case CELL_TYPE_BOOLEAN :
                BoolErrRecord boolRec = null;

View Full Code Here

    Sheet sheet = Sheet.createSheet();


    RowRecord rr = new RowRecord(5);
    sheet.addRow(rr);


    CellValueRecordInterface cvr = new BlankRecord();
    cvr.setColumn((short)0);
    cvr.setRow(5);
    sheet.addValueRecord(5, cvr);




    int dbCellRecordPos = getDbCellRecordPos(sheet);
    if (dbCellRecordPos == 252) {

View Full Code Here

                }
                _record = lrec;
                break;


            case CELL_TYPE_BLANK :
                BlankRecord brec = null;


                if (cellType != _cellType)
                {
                    brec = new BlankRecord();
                }
                else
                {
                    brec = ( BlankRecord ) _record;
                }
                brec.setColumn(col);


                // During construction the cellStyle may be null for a Blank cell.
                brec.setXFIndex(styleIndex);
                brec.setRow(row);
                _record = brec;
                break;


            case CELL_TYPE_BOOLEAN :
                BoolErrRecord boolRec = null;

View Full Code Here

    case SSTRecord.sid:
      sstRecord = (SSTRecord) record;
      break;


    case BlankRecord.sid:
      BlankRecord brec = (BlankRecord) record;


      thisRow = brec.getRow();
      thisColumn = brec.getColumn();
      thisStr = "";
      break;
    case BoolErrRecord.sid:
      BoolErrRecord berec = (BoolErrRecord) record;

View Full Code Here

                }
                _record = lrec;
                break;


            case CELL_TYPE_BLANK :
                BlankRecord brec = null;


                if (cellType != _cellType)
                {
                    brec = new BlankRecord();
                }
                else
                {
                    brec = ( BlankRecord ) _record;
                }
                brec.setColumn(col);


                // During construction the cellStyle may be null for a Blank cell.
                brec.setXFIndex(styleIndex);
                brec.setRow(row);
                _record = brec;
                break;


            case CELL_TYPE_BOOLEAN :
                BoolErrRecord boolRec = null;

View Full Code Here

            MulBlankRecord mb = ( MulBlankRecord ) retval;


            realretval = new Record[ mb.getNumColumns() ];
            for (int k = 0; k < mb.getNumColumns(); k++)
            {
                BlankRecord br = new BlankRecord();


                br.setColumn(( short ) (k + mb.getFirstColumn()));
                br.setRow(mb.getRow());
                br.setXFIndex(mb.getXFAt(k));
                realretval[ k ] = br;
            }
        }
        if (realretval == null)
        {

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

com.common.platform.excel.parser.HSSFParser

evolaris.framework.sys.business.XLS2CSVmra

org.apache.poi.hssf.eventmodel.EventRecordFactory

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

org.apache.poi.hssf.eventusermodel.MissingRecordAwareHSSFListener

org.apache.poi.hssf.model.TestSheet

org.apache.poi.hssf.record.aggregates.TestValueRecordsAggregate

org.apache.poi.hssf.record.aggregates.ValueRecordsAggregate

org.apache.poi.hssf.usermodel.HSSFCell

org.apache.poi.hssf.usermodel.TestHSSFRow

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.