Package org.apache.poi.ss.formula.udf

Examples of org.apache.poi.ss.formula.udf.UDFFinder

104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
        };

        /**
         * register the two test UDFs in a UDF finder, to be passed to the evaluator
         */
        UDFFinder udff1 = new DefaultUDFFinder(new String[] { "myFunc", },
                new FreeRefFunction[] { NotImplemented });
        UDFFinder udff2 = new DefaultUDFFinder(new String[] { "myFunc2", },
                new FreeRefFunction[] { NotImplemented });
        UDFFinder udff = new AggregatingUDFFinder(udff1, udff2);
        assertNotNull(wb.getNameXPtg("myFunc", udff));
        assertNotNull(wb.getNameXPtg("myFunc2", udff));

        assertNull(wb.getNameXPtg("myFunc3", udff));  // myFunc3 is unknown
    }
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
            FreeRefFunction function = xlsMacroList.get(name);
            names[x] = name;
            functions[x] = function;
        }

        UDFFinder udff1 = new DefaultUDFFinder(names, functions);
        UDFFinder udff = new AggregatingUDFFinder(udff1);

        return udff;

    }
View Full Code Here
81
82
83
84
85
86
87
88
89
    assertNotNull( fixture ) ;
   
    fixture.addFunction("h2_ZFactor", new CalculateMortgageFunction() ) ;
   
    UDFFinder functions = fixture.getFunctions() ;
   
    assertNotNull( functions ) ;
  }
View Full Code Here
79
80
81
82
83
84
85
86
87
    assertNotNull( fixture ) ;
   
    fixture.addFunction("h2_ZFactor", new CalculateMortgageFunction() ) ;
   
    UDFFinder functions = fixture.getFunctions() ;
   
    assertNotNull( functions ) ;
  }
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
    HSSFSheet sheet = wb.getSheetAt(0);

    /**
     * register the two test UDFs in a UDF finder, to be passed to the evaluator
     */
    UDFFinder udff1 = new DefaultUDFFinder(new String[] { "myFunc", },
        new FreeRefFunction[] { new MyFunc(), });
    UDFFinder udff2 = new DefaultUDFFinder(new String[] { "myFunc2", },
        new FreeRefFunction[] { new MyFunc2(), });
    UDFFinder udff = new AggregatingUDFFinder(udff1, udff2);


    HSSFRow row = sheet.getRow(0);
    HSSFCell myFuncCell = row.getCell(1); // =myFunc("_")

View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
            fis.close();

            String[] functionNames = { "calculatePayment" } ;
            FreeRefFunction[] functionImpls = { new CalculateMortgage() } ;
           
            UDFFinder udfToolpack = new DefaultUDFFinder( functionNames, functionImpls ) ;

            // register the user-defined function in the workbook
            workbook.addToolPack(udfToolpack);

            FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator();
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
        };

        /**
         * register the two test UDFs in a UDF finder, to be passed to the evaluator
         */
        UDFFinder udff1 = new DefaultUDFFinder(new String[] { "myFunc", },
                new FreeRefFunction[] { NotImplemented });
        UDFFinder udff2 = new DefaultUDFFinder(new String[] { "myFunc2", },
                new FreeRefFunction[] { NotImplemented });
        UDFFinder udff = new AggregatingUDFFinder(udff1, udff2);
        assertNotNull(wb.getNameXPtg("myFunc", udff));
        assertNotNull(wb.getNameXPtg("myFunc2", udff));

        assertNull(wb.getNameXPtg("myFunc3", udff));  // myFunc3 is unknown
    }
View Full Code Here
50
51
52
53
54
55
56
57
58
    assertNotNull( fixture ) ;
   
    fixture.addFunction("h2_ZFactor", new CalculateMortgageFunction() ) ;
   
    UDFFinder functions = fixture.getFunctions() ;
   
    assertNotNull( functions ) ;
  }
View Full Code Here
50
51
52
53
54
55
56
57
58
    assertNotNull( fixture ) ;
   
    fixture.addFunction("h2_ZFactor", new CalculateMortgage() ) ;
   
    UDFFinder functions = fixture.getFunctions() ;
   
    assertNotNull( functions ) ;
  }
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
        };

        /**
         * register the two test UDFs in a UDF finder, to be passed to the evaluator
         */
        UDFFinder udff1 = new DefaultUDFFinder(new String[] { "myFunc", },
                new FreeRefFunction[] { NotImplemented });
        UDFFinder udff2 = new DefaultUDFFinder(new String[] { "myFunc2", },
                new FreeRefFunction[] { NotImplemented });
        UDFFinder udff = new AggregatingUDFFinder(udff1, udff2);
        assertNotNull(wb.getNameXPtg("myFunc", udff));
        assertNotNull(wb.getNameXPtg("myFunc2", udff));

        assertNull(wb.getNameXPtg("myFunc3", udff));  // myFunc3 is unknown
    }
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.formula.udf.UDFFinder

  • org.apache.poi.hssf.model.TestWorkbook
  • org.apache.poi.ss.examples.formula.UserDefinedFunctionExample
  • org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil
  • org.apache.poi.ss.excelant.util.TestExcelAntWorkbookUtil
  • org.apache.poi.ss.formula.eval.TestExternalFunction
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.