Free Support Forum - aspose.com

New function request

Hi,
I have a new function request. Can you provide a way or a iterator that iterates through only a list of “data cells” (cells that has data, ignore all the empty cells)? That way, we don’t have to write nested loop to go through the entire spreadsheet.

I’m trying to gather data from the spreadsheet but doing nested loop is really inefficient.

for (int x = 0; x < worksheet.Cells.MaxDataRow; x++) //there is a lot of empty rows that can be ignored
{
for (int y = 0; y < worksheet.Cells.MaxDataColumn; y++) //there is a lot of empty columns that can be ignored.
{
if (worksheet.Cells[x, y].Value != null)
dosomething()
}
}

So instead of something like above. Maybe use a

<?xml:namespace prefix = o ns = “urn:schemas-microsoft-com:office:office” /><o:p>

Hi,

Thank you for considering Aspose.

We will look into the feasibility of your required issue and get back to you soon. New feature request has been logged in our issue tracking system as Issue Id CELLSNET-11054.

Thank You & Best Regards,

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

Also, you may try to reduce one loop from your current code to optimize your code a bit by using the following approach:

Cells cells = workbook.Worksheets[0].Cells;

for (IEnumerator ie = cells.GetEnumerator(); ie.MoveNext(); )

{

Cell cell = (Cell)ie.Current;

if (cell.Value != null)

{

//do something

}

}

Thank You & Best Regards,