Tag Archives: excel

Table Function Demo with Microsoft Excel

As mentioned earlier in a related article Table Functions of the .NET libraries finaquant® calcs (commercial) or finaquant® protos (non-commercial) can be called from an excel sheet. Following example demonstrates: How Table Functions can be called from excel macros (VBA) … Continue reading

Posted in Calculation engine | Tagged , , | 2 Comments

Table Functions in Visual Basic (VB.net)

Table Functions of our .NET (dot net) libraries finaquant® protos (non-commercial) or finaquant® calcs (commercial) can be called in other .NET languages including Visual Basic. The ability to call Table Functions in Visual Basic can make the transition from VBA … Continue reading

Posted in Calculation engine | Tagged , , | Leave a comment

Calling table functions from Microsoft Excel

This article explains how the table functions of the non-commercial .net library finaquant® protos can be called from within Microsoft Excel using VBA macros. Two possible integration options are presented here: 1) Calling a .net method from an Excel macro … Continue reading

Posted in Calculation engine | Tagged , , , | 1 Comment

Importing and Exporting a DataTable from/to an Excel file

As explained in the related article, a MatrixTable of finaquant can easily be converted to or from a DataTable of the .net framework (ADO.net). That is, importing or exporting a MatrixTable from/to an excel sheet can be accomplished in two … Continue reading

Posted in Calculation engine | Tagged , , | 5 Comments