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

Getting a cellvalue in workbook slowing the performance in result

Nov 14, 2016 at 2:32 PM
Hi ,
dll version : 4.0.5
I am using countifs formula then calculate function and after that when trying to get the cell value like ( String val22 = (String)SummarysheetModel.Cells[k, 201, k, 201].Value.ToString(); ) , system getting slow at debugging and release mode.

I have lots of entries in Excel worksheet and want to calculate each cell and show in new worksheet.

Please let me know if this is a correct to get the cell value.
sheet["B3"].Formula = "COUNTIFS(Data!V:V,\"CODE\",Data!AL:AL,\"MODEL\")";
sheet.Cells[k, 201, k, 201].Calculate();
String val22 = (String)sheet.Cells[k, 201, k, 201].Value.ToString();
Developer
Nov 16, 2016 at 8:12 PM
Hi,

could you attach a logger to the formula parser before Calculate() is called?

https://epplus.codeplex.com/wikipage?title=About%20Formula%20calculation&referringTitle=Documentation

Then look in the logfile and share the details of the log here; how many cells are calculated, how long time did the calculation take, etc?

Thanks,

Mats
Dec 6, 2016 at 1:46 PM
Thanks for update.
I will check and let you know the log details asap.


Regards,
Hemant