Hi Q,
Sorry for the delay in responding.
Slow performance when looping through IRange[x,y]: I am not able to reproduce the issue that you mentioned here. As per your requirements I have created one sample and checked the performance. The performance is good. I have tested this issue in the following environment Windows xp with service pack2, office 2003, VisualStudio 2005,.Net framework 2.0.
Here is the sample for your reference:
http://websamples.syncfusion.com/samples/XlsIO.Windows/72472/main.htm Please have a look at the above sample and if still the issue exists, could you please try reproducing it in the above sample and send us the modified sample so that we could sort out the cause of the issue
and provide you a solution?
Also, please provide your system details and office version.
Regards,
G.Yavana