为什么不直接用在模板里面写foxtable的公式?
http://www.foxtable.com/webhelp/scr/1388.htm
http://www.foxtable.com/webhelp/scr/1415.htm
如果生成excel后,需要excel公式生效,可以用vba打开,然后执行
Dim App As New MSExcel.ApplicationDim Wb As MSExcel.WorkBook = App.WorkBooks.Open("D:\test.xls")Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1)ws.Calculate()App.Visible = True