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.
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,