EzXlsFinancial 1.0.2

A simple library that utilizes NPOI to calculate excel functions exactly as excel does.

Install-Package EzXlsFinancial -Version 1.0.2
dotnet add package EzXlsFinancial --version 1.0.2
<PackageReference Include="EzXlsFinancial" Version="1.0.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add EzXlsFinancial --version 1.0.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

EzXlsFinancial - Easy Excel Financial Objects

A project that I am working on requires the value for NPV to be exactly what excel gives. Me and my colleague spent days using whatever library we could.
We understand how the algorthim works and used all sorts of sample code and still we could not get the numbers to line up. This project is patterned in a way that should
make it easy to create objects to use every bit of excel formulas. Basically we write to columns, set the formulas, cause a recalc, read the number we need, profit?

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes.

Using this project:

Please see the xunit .Tests project included to see samples of how this is used.

Deployment

This project was design to be hosted and distributed with nuget.com.

Built With

Contributing

Please read CONTRIBUTING.md for details on our code of conduct, and the process for submitting pull requests to us.

Versioning

We use SemVer for versioning. For the versions available, see the tags on this repository.

Authors

License

This project is licensed under the MIT License - see the LICENSE.md file for details

Acknowledgments

Many thanks to the following projects that have helped in this project

  • NPOI

EzXlsFinancial - Easy Excel Financial Objects

A project that I am working on requires the value for NPV to be exactly what excel gives. Me and my colleague spent days using whatever library we could.
We understand how the algorthim works and used all sorts of sample code and still we could not get the numbers to line up. This project is patterned in a way that should
make it easy to create objects to use every bit of excel formulas. Basically we write to columns, set the formulas, cause a recalc, read the number we need, profit?

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes.

Using this project:

Please see the xunit .Tests project included to see samples of how this is used.

Deployment

This project was design to be hosted and distributed with nuget.com.

Built With

Contributing

Please read CONTRIBUTING.md for details on our code of conduct, and the process for submitting pull requests to us.

Versioning

We use SemVer for versioning. For the versions available, see the tags on this repository.

Authors

License

This project is licensed under the MIT License - see the LICENSE.md file for details

Acknowledgments

Many thanks to the following projects that have helped in this project

  • NPOI

Release Notes

We can now process NPV calculations exactly as Excel does.  We also can handle more than 38 rows which the release version could not do.  This can now handle 1000 values in the NPV calc.

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.0.2 22 10/12/2019
1.0.0 60 7/13/2019