有一个.NET库可以进行财务计算或实现类似Excel的功能吗?

时间:2021-01-19 12:33:45

I'm working in a ASP.NET project wich is suposed to do several financial calculantions involving potentiations, nth roots, etc. For this first operations, I can easily solve the problem using Math. But, for calculating work days - like Excel, or monthly loan payment, interest rates, etc. - like HP 12C, there is a library that implements these functions? Thanks!

我正在一个ASP.NET项目中工作,它可以进行几个涉及增强,第n个根等的财务计算。对于第一个操作,我可以使用Math轻松解决问题。但是,为了计算工作日 - 如Excel,或每月贷款支付,利率等 - 如HP 12C,有一个实现这些功能的库?谢谢!

2 个解决方案

#1


3  

You might want to check out the Excel Financial functions for .NET

您可能想要查看.NET的Excel财务功能

This is a .NET library that provides the full set of financial functions from Excel. The main goal for the library is compatibility with Excel, by providing the same functions, with the same behaviour. 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.

这是一个.NET库,它提供Excel的全套财务功能。该库的主要目标是与Excel兼容,提供相同的功能,具有相同的行为。请注意,这不是Excel库的包装器;这些函数已在托管代码中重新实现,因此您无需安装Excel即可使用此库。

The Microsoft.VisualBasic assembly in .NET 4.0 also exposes some financial functions. Even though they are ostensibly VB 4.0 keywords there is nothing stopping you from referencing them from a C# or other CLR language project (I'm assuming they are CLR-compliant).

.NET 4.0中的Microsoft.VisualBasic程序集还公开了一些财务功能。即使它们表面上是VB 4.0关键字,也没有什么能阻止您从C#或其他CLR语言项目中引用它们(我假设它们符合CLR)。

#2


2  

Have you looked at Open source or free financial analysis programs/libraries

你看过开源或免费的财务分析程序/库吗?

#1


3  

You might want to check out the Excel Financial functions for .NET

您可能想要查看.NET的Excel财务功能

This is a .NET library that provides the full set of financial functions from Excel. The main goal for the library is compatibility with Excel, by providing the same functions, with the same behaviour. 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.

这是一个.NET库,它提供Excel的全套财务功能。该库的主要目标是与Excel兼容,提供相同的功能,具有相同的行为。请注意,这不是Excel库的包装器;这些函数已在托管代码中重新实现,因此您无需安装Excel即可使用此库。

The Microsoft.VisualBasic assembly in .NET 4.0 also exposes some financial functions. Even though they are ostensibly VB 4.0 keywords there is nothing stopping you from referencing them from a C# or other CLR language project (I'm assuming they are CLR-compliant).

.NET 4.0中的Microsoft.VisualBasic程序集还公开了一些财务功能。即使它们表面上是VB 4.0关键字,也没有什么能阻止您从C#或其他CLR语言项目中引用它们(我假设它们符合CLR)。

#2


2  

Have you looked at Open source or free financial analysis programs/libraries

你看过开源或免费的财务分析程序/库吗?