View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gutta gutta is offline
external usenet poster
 
Posts: 1
Default Excel cell by cell writing.

int ePointer = ir.GetEntryPointer();
Xl.Worksheet sheet =
(Xl.Worksheet)DotNetInsFunctions.xlApp.Worksheets[ir.GetInfo().Sheet];
while(ePointer = 0)
{
Entry e = ir.GetEntry(ePointer);
Xl.Range cell =
(Xl.Range)sheet.Cells[e.row,e.column];
cell.Value2 = e.initValue;
ePointer = ir.GetEntryPointer();
}


In the above code, if the while loop executes for 10,000 cells, it
takes 300sec to write values to 10,000 cells. If I want to do a cell
by cell writing, this is how slow it is performing..
Does anyone know of any other effective and fast way of writing stuff
to sheet in a cell by cell manner.