Regarding method usage

Aspose.Cells Product Family
1

Hi,

I'm using getCells() method in NamedRange in version 2.5.3. Can you please tell me the similar method in v8.3?

Regards,

Amit

2

Hi,

Thanks for your posting and using Aspose.Cells.

Now, instead of NamedRange, you have Name and Name has a method getRange(), it will return you Range object which has an iterator Range.iterator()

So the code will look like this

Java


Name nm = …;

Range r = nm.getRange();


for(Iterator it = r.iterator(); it.hasNext():wink: {

Cell c = (Cell) it.next();

System.out.println("getLeafs(): " + c.getRow() + “;” + c.getColumn());

}