We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Equivalent of Workbook.Names?

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

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/creating-a-named-range.html

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/create-workbook-global-worksheet-scoped-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