Excel Functions


#1

Do you have an expected date on the addition of the new functions to the formula engine? I have attached a s/s that is commonly used in excel for loan amortizations. The functions I use in this s/s are Sum, Round, VLookup,IF,CountIF,IRR, PMT, Month,Day,Date and Year.

Our ideal scenario is to open this s/s in code on the asp.net server, input the cells, calculate the sheet, and then grab some of the calculated fields without ever showing the s/s to the end user (but saving a copy).

However this doesn't work, I'm assuming we are getting a null reference due to the limited support of the functions when we try this with the evaluation version. We are just testing a simple snippet of code. It errors on the Calculate Formula. Without that line is opens and saves fine.

Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
Dim ss As New Excel()
ss.Open(Server.MapPath("apr.xls"))
Dim LoanCell As Cell = ss.Worksheets(0).Cells("C3")
LoanCell.PutValue(20000)
ss.CalculateFormula()
Response.Write(ss.Worksheets(0).Cells("C3").Value)
ss.Save(Server.MapPath("apr.xls"), FileFormatType.Default)
End Sub


#2

Currently in your requested functions, only Sum, Round and IF are supported. I will implement them in the future release.

I think VLookup, IRR and PMT are more complex than others.