Excel UsedRange

RE: Excel UsedRange

Microsoft.Office.Interop.Excel. has a Worksheet.UsedRange.

How do I get the used range in Aspose.Cells?

Many thanks in advance.

Regards,

Neil.


Hi Neil,

Thanks for considering Apose.Cells, you can implement the range functionality using following code.

//Creating a named range
Range range = worksheet.Cells.CreateRange(“B4”, “G14”);
//Setting the name of the named range
range.Name = “TestRange”;

For further detail you can visit the following link.

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/named-ranges.html

In case of any further support please feel free to contact us.

Best Regards,