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

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

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));

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
74
75
76
77
78
79
80
81
82
83
84
85
86
    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);
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
        };

        /**
         * 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));

View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
113
114
        };

        /**
         * 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));

View Full Code Here
141
142
143
144
145
146
147
148
149
150
151
            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
57
58
59
60
61
62
63
64
65
66
67
            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
TOP

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

  • org.apache.poi.hssf.model.TestWorkbook
  • org.apache.poi.ss.examples.formula.UserDefinedFunctionExample
  • org.apache.poi.ss.excelant.util.ExcelAntWorkbookUtil
  • 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.