Examples of org.apache.poi.hssf.util.SheetReferences

org.apache.poi.hssf.util.SheetReferences
Holds a collection of Sheet names and their associated reference numbers. @author Andrew C. Oliver (acoliver at apache dot org)

    protected Record createEOF() {
        return new EOFRecord();
    }


    public SheetReferences getSheetReferences() {
        SheetReferences refs = new SheetReferences();
        
        if (externSheet != null) {
            for (int k = 0; k < externSheet.getNumOfREFStructures(); k++) {
                
                String sheetName = findSheetNameFromExternSheet((short)k);
                refs.addSheetReference(sheetName, k);
                
            }
        }
        return refs;
    }

View Full Code Here

    protected Record createEOF() {
        return new EOFRecord();
    }


    public SheetReferences getSheetReferences() {
        SheetReferences refs = new SheetReferences();
        
        if (externSheet != null) {
            for (int k = 0; k < externSheet.getNumOfREFStructures(); k++) {
                
                String sheetName = findSheetNameFromExternSheet((short)k);
                refs.addSheetReference(sheetName, k);
                
            }
        }
        return refs;
    }

View Full Code Here

        // TODO - there are 3 ways this method can return null. Is each valid?
        if (book == null) {
            return null;
        }


        SheetReferences refs = book.getSheetReferences();
        if (refs == null) {
            return null;
        }
        return refs.getSheetName(externSheetIndex);
    }

View Full Code Here

        }
        return linkTable;
    }


    public SheetReferences getSheetReferences() {
        SheetReferences refs = new SheetReferences();
        
        if (linkTable != null) {
            int numRefStructures = linkTable.getNumberOfREFStructures();
            for (short k = 0; k < numRefStructures; k++) {
                
                String sheetName = findSheetNameFromExternSheet(k);
                refs.addSheetReference(sheetName, k);
                
            }
        }
        return refs;
    }

View Full Code Here

    protected Record createEOF() {
        return new EOFRecord();
    }


    public SheetReferences getSheetReferences() {
        SheetReferences refs = new SheetReferences();
        
        if (externSheet != null) {
            for (int k = 0; k < externSheet.getNumOfREFStructures(); k++) {
                
                String sheetName = findSheetNameFromExternSheet((short)k);
                refs.addSheetReference(sheetName, k);
                
            }
        }
        return refs;
    }

View Full Code Here

    protected Record createEOF() {
        return new EOFRecord();
    }


    public SheetReferences getSheetReferences() {
       SheetReferences refs = new SheetReferences();


       if (externSheet != null) {
          for (int k = 0; k < externSheet.getNumOfREFStructures(); k++) {
              String sheetName = findSheetNameFromExternSheet((short)k);
              refs.addSheetReference(sheetName, k);
          }
       }
       return refs;
    }

View Full Code Here


  }


  public String toFormulaString(Workbook book)
  {
    SheetReferences refs = book == null ? null : book.getSheetReferences();
    StringBuffer retval = new StringBuffer();
    if ( refs != null )
    {
      retval.append( refs.getSheetName( this.field_1_index_extern_sheet ) );
      retval.append( '!' );
    }
    retval.append( ( new CellReference( getFirstRow(), getFirstColumn(), !isFirstRowRelative(), !isFirstColRelative() ) ).toString() );
    retval.append( ':' );
    retval.append( ( new CellReference( getLastRow(), getLastColumn(), !isLastRowRelative(), !isLastColRelative() ) ).toString() );

View Full Code Here

    protected Record createEOF() {
        return new EOFRecord();
    }


    public SheetReferences getSheetReferences() {
        SheetReferences refs = new SheetReferences();
        
        if (externSheet != null) {
            for (int k = 0; k < externSheet.getNumOfREFStructures(); k++) {
                
                String sheetName = findSheetNameFromExternSheet((short)k);
                refs.addSheetReference(sheetName, k);
                
            }
        }
        return refs;
    }

View Full Code Here

        }
        return linkTable;
    }


    public SheetReferences getSheetReferences() {
        SheetReferences refs = new SheetReferences();
        
        if (linkTable != null) {
            int numRefStructures = linkTable.getNumberOfREFStructures();
            for (short k = 0; k < numRefStructures; k++) {
                
                String sheetName = findSheetNameFromExternSheet(k);
                refs.addSheetReference(sheetName, k);
                
            }
        }
        return refs;
    }

View Full Code Here


    }


    public String toFormulaString(Workbook book) {
        StringBuffer retval = new StringBuffer();
        SheetReferences refs = book == null ? null : book.getSheetReferences();
        if (refs != null) {
            retval.append(refs.getSheetName((int)this.field_1_index_extern_sheet));
            retval.append('!');
        }
        retval.append((new CellReference(getRow(),getColumn(),!isRowRelative(),!isColRelative())).toString()); 
        return retval.toString();
    }

View Full Code Here

0 1 2 3 4

TOP

Related Classes of org.apache.poi.hssf.util.SheetReferences

org.apache.poi.hssf.eventusermodel.TestEventWorkbookBuilder

org.apache.poi.hssf.model.FormulaParser

org.apache.poi.hssf.model.TestFormulaParser

org.apache.poi.hssf.model.Workbook

org.apache.poi.hssf.record.formula.Area3DPtg

org.apache.poi.hssf.record.formula.Ref3DPtg

org.apache.poi.hssf.usermodel.HSSFCell

org.apache.poi.hssf.usermodel.HSSFName

java.util.HashMap

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.