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)

        // 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

    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

   
    /** toString on the parser instance returns the RPN ordered list of tokens
     *   Useful for testing
     */
    public String toString() {
        SheetReferences refs = book.getSheetReferences();
        StringBuffer buf = new StringBuffer();
           for (int i=0;i<tokens.size();i++) {
            buf.append( ( (Ptg)tokens.get(i)).toFormulaString(refs));
            buf.append(' ');
        }

View Full Code Here

     * @return reference of the named range
     */    


    public String getReference() {
        String result;
        SheetReferences refs = book.getSheetReferences();
        result = name.getAreaReference(refs);


        return result;
    }

View Full Code Here

        }
    }


    public String getCellFormula() {
        //Workbook.currentBook=book;
        SheetReferences refs = book.getSheetReferences();
        String retval = FormulaParser.toFormulaString(refs, ((FormulaRecordAggregate)record).getFormulaRecord().getParsedExpression());
        //Workbook.currentBook=null;
        return retval;
    }

View Full Code Here

        AttrPtg funif = (AttrPtg) asts[3];


        assertEquals(true, flag.getValue());
        assertEquals("Y", y.getValue());
        assertEquals("N", n.getValue());
        assertEquals("IF", funif.toFormulaString(new SheetReferences()));
    }

View Full Code Here

   
    /** toString on the parser instance returns the RPN ordered list of tokens
     *   Useful for testing
     */
    public String toString() {
        SheetReferences refs = book.getSheetReferences();
        StringBuffer buf = new StringBuffer();
           for (int i=0;i<tokens.size();i++) {
            buf.append( ( (Ptg)tokens.get(i)).toFormulaString(refs));
            buf.append(' ');
        }

View Full Code Here

     * @return reference of the named range
     */    


    public String getReference() {
        String result;
        SheetReferences refs = book.getSheetReferences();
        result = name.getAreaReference(refs);


        return result;
    }

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 getCellFormula() {
        //Workbook.currentBook=book;
        SheetReferences refs = book.getSheetReferences();
        String retval = FormulaParser.toFormulaString(refs, ((FormulaRecordAggregate)record).getFormulaRecord().getParsedExpression());
        //Workbook.currentBook=null;
        return retval;
    }

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.