I am wondering how one accesses the Excel collection Workbook.Names, which can hold a collection of named ranges?
… and I also need the equivalent of Worksheet.UsedRange. Thanks.
Hi Jeff,
Please follow the links given below for details.
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/named-ranges.html
If there is unclear, please feel free to reach us.
Thanks,
Thanks, that will work. I then used the name of the range as the parameter to Workbook.Worksheets.GetRangeByName(rangeName) to get the Range object.
As for UsedRange, it appears I can substitute the Worksheet.Cells.MaxRow, MinRow, MaxColumn, MinColumn.
Thanks,
Jeff