Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
C# worksheet function poor performance
Hi
I've written a simple worksheet function in C#. there is no shim, just .net. The function takes an excel range and loops through each cell and is very slow, something like 200 times slower than the Excel equivalent or the vba equivalent. The code is on another machine but is basically public double TheFunction( Range rngList){ for(long i = rngList.Rows.Count; i0; i--) // do some simple adding (using range.value2 etc and finish I was wondering if accessing the range inside the loop was the problem, or has anyone got any suggestions? cheers Simon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Very poor performance with Excel 2007 | Excel Discussion (Misc queries) | |||
Performance in excel 97 is poor | Excel Discussion (Misc queries) | |||
Poor Worksheet Performance (for Mike Malachy) | Excel Programming | |||
poor subroutine performance | Excel Programming | |||
Poor Worksheet Performance | Excel Programming |