This project has moved and is read-only. For the latest updates, please go here.

Don't find method calculate in workbook

Mar 20, 2015 at 10:25 AM
Hi,

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.Load(fsFC)
fsFC.Close()
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?

Thanks.
Oct 15, 2015 at 4: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 2:01 PM
Hi,

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.

Regards