OWC10 spreadsheet component question

  • Thread starter Thread starter xargon
  • Start date Start date
X

xargon

Hi everyone,

I have a question regarding the insertion speed in the Office XP we
component's spreadsheet component. I am creating an ASP.NET applicatio
where I use the spreadsheet component. I was testing how fast th
insertions take place in the component. Everything is happening locall
over ASP.NET

I did a simple test like so:

I have a Worksheet object called sheet;

Code
-------------------

for (int i = 1; i < 2000; i++)
{
for (int j = 0; j < 20; j++)
{
sheet.Cells[i, j] = "test";
}
}

-------------------


This never finishes...or I never waited till it finished. It seems lik
the insertion speed on the spreadsheet component is really slow. O
maybe I am doing it the wrong way. Any suggestions on this would b
really welcome.

I have datasets that can easily extend 2000 records. However, I a
hoping there exists a better way of doing this. The documentation o
this component is very scarse and does not discuss good practices o
doing such things.

I am hoping someone who had experience with this component would rea
this soon :)

Any help would be greatly appreciated.

Thanks,

Pankaj aka xargo
 
Back
Top