Article Details
Id: | 15154 |
Product: | finPOWER Connect |
Type: | NEW |
Version: | 3.01.00 |
Opened: | 04/01/2018 |
Closed: | 12/01/2018 |
Released: | 23/02/2018 |
Job: | J020055 |
ISExcel object; now supports a basic calculation engine
The ISExcelWorkbook and Worksheet objects now supports a calculation engine.
This allows either the entire Workbook or a single Worksheet to be calculated.
With finBL.CreateExcelWorkbook
' Add a Worksheet
.Worksheets.Add("TEST")
With .Worksheets(0)
.Cell("A1").SetDecimal(100)
.Cell("A2").SetDecimal(200)
.Cell("A3").Formula = "=A1+A2"
.Cell("A4").Formula = "=A3*2"
.Cell("A5").Formula = "=SUM(A1:A4)"
.Cell("A7").Formula = "=A8"
.Cell("A8").Formula = "=100"
' Create a circular reference formula
.Cell("A10").Formula = "=A1+A10"
.Cell("A11").Formula = "=A10/A1"
End With
' Calculate Workbook (note we have a circular reference so set Iterative option to True
.CalculationOptions.EnableIterativeCalculation=True
.Calculate()
' Save
.Save("c:\temp\test.xlsx")
.Save("c:\temp\test.pdf")
End With
One of the benefits of using the Calculation facilities is that a PDF document can be generated within finPOWER Connect, as per the example above.
Note, the Calculation Engine is beta, and may not support all formulas found in Microsoft Excel.