NET implementation which supports the standard. NET Standard 2.0 library, which you can add to any projectīased on a. Adding it to your projectĮxcel Financial Functions is a. These should be run on a Windows machine with Excel 2013 (or later) installed.įound a discrepency? Open an Issue! Or better yet, a Pull Request. ExcelFinancialFunctions.ConsoleTests: Test cases comparing the library results directly to running Excel code via interop.Inputs and expected outputs are read from data files. ExcelFinancialFunctions.Tests: Unit tests checking against previously-determined truth values from Excel 2010.Thoroughly testedĪs of last count, the library is validated against 199,252 test cases. The scope for this library is the full set of functions in the "Financial Functions" category. Microsoft's official documentation on Excel Functions is the best place to learn more about how the functions should work. Please have a look at the Compatibility page for more detail on this topic. We replicate the results Excel would produce in every situation,Įven in cases where we might disagree with Excel's approach. Note though that this is not a wrapper over the Excel library the functions have been re-implemented in managed code so that you do not need to have Excel installed to use this library. The main goal for the library is compatibility with Excel, by providing the same functions, with the same behaviour. NET Standard library that provides the full set of financial functions from Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |