Re: EPPlus - Formula

Harry Kleinsmit

Hi Pavel,

Formula's usually start with and '=' sign. So in your case it should probably be:

EvaluateExpression( Worksheet.Cells['A1'].Formula='=Count(B1:B10)' )

Best regards,

Harry Kleinsmit.

On Fri, Apr 28, 2017 at 05:41 am, Pavel Mencl wrote:


I'm trying to set a cell to a formula like Count(range)  with

EvaluateExpression( Worksheet.Cells['A1'].Formula='Count(B1:B10)' )

but that doesn't work.

What am I missing?




Join { to automatically receive all group messages.