Posted 8 September 2017, 2:35 pm EST
I'm finding that writing into a large number of rows/cells to be very slow. Is there a faster way to do this? (Assuming the "temp" values are different for each cell)
The following takes 14 sec to run (in Debug mode). (Where Columns is 20)
MySheet.RowCount = 450;
for (int i = 0; i < 450; i++)
foreach (FP.Spread.Column column in MySheet.Columns)
MySheet.Cells[row, column.Index].Text = "temp";
Thanks for the help!