This project has moved. For the latest updates, please go here.

Don't find method calculate in workbook

Mar 20, 2015 at 9:25 AM

I'm evaluating the component but I have a problem with the method Calculate because the solution doesn't compile.

Dim excP As New OfficeOpenXml.ExcelPackage
Dim fsFC As System.IO.FileStream
excP.Workbook.Calculate() --> The compiler doesn't find the method

I'm using the latest version of EPPlus 4.0.3

Can anybody help me?

Oct 15, 2015 at 3:33 AM
Happened to me also...
Just add the "using" statement instead of referencing on the instantiate:

using OfficeOpenXml;
using OfficeOpenXml.FormulaParsing;

That will bring you the Calculate() method.

good luck
Oct 17, 2015 at 1:01 PM

Do you have a small example?

I'm trying to add in the top of the class Imports OfficeOpenXML and OfficeOpenXml.FormulaParsing like your using but it happens the same.

If you can send me a complete code of a small example it will be perfect for me.

Sorry for the inconveniences.