This project has moved and is read-only. For the latest updates, please go here.

DGET function

Mar 9, 2015 at 8:19 AM
We recently tested EPPlus and it's perfect for our project - Thanks!

However there is one thing (really only one!) that is missing, and it's support of DGET function.

We succeeded in using VLOOKUP instead but it's not "classic" and since we have lots of excels that uses DGET, it's critical.

Can you please guide me how to add this? I didn't really get it from the docs...

We use EPPlus on a web-app if this changes anything.

Alternately, If it's a reasonable task that you guys can add for reasonable fee, this may be good solution for us!
Mar 13, 2015 at 3:34 PM
Hi,

you can add custom functions to the formula parser in runtime. Just inherit the class ExcelFunction and implement the function in c# code. Custom functions are added to the parser via Workbook.FormulaParserManager. You can see in the sample project (see the downloads section) how this can be done.