Avoid iteration using Aspose for excel

Aspose.Cells Product Family
1

I have 10000 rows in excel… Im making particular column as ‘0’ if it is null using Aspose…
For this Im using “for loop” condition which giving timeout error.
Any short cut condition to avoid iteration …

if(column2 isnull)
{
cell =0
}


(Or)
Any excel validation available inbuilt.?


2

Hi,


Thanks for providing us some details.

See the sample code segment for your reference if it helps you to accomplish the task.
e.g
Sample code:

…
int tRows = 1000;
Cells cells = workbook.Worksheets[0].Cells;
for (int i = 0; i < tRows; i++)
{
Row row = cells.Rows.GetRowByIndex(i);
for (int j = 0; j < cells.MaxColumn; j++)
{
Aspose.Cells.Cell cell = row.GetCellOrNull(j);
if (cell == null && cell.Type == CellValueType.IsNull)
{
//…
//Your code goes here.
//…
}
}
}
…

Hope, this helps you.

Thank you.