Create and Access Named Ranges in Excel spreadsheet in .NET

Aspose.Cells Product Family
1

What if you have a named range?

PriceList is a named range with many rows of data

MaxVal is a dynamic entry from a cell used to locate a row in a table.

How do I loop through the range. How would you create a custom function with named range?

For example MyFunc(PriceList, MaxVal)

or

Range(MaxVal).Value = 34

I Also want to refer to a named range withing the enire workbook not just the worksheet.

Thank you,
2

Hi,

We are not clear about your requirement. Please provide some further details about what your custom function will do and how you want to utilize the parameters in the custom function.

Thank you & Best Regards,

3

Sorry for not being very clear. I just want to know how to get/set a value from a named range without going through alot of extra steps. In Excel it is reletively easy, single range cell:

Dim MyString as String = xlApp.Range(MyRange).Value

or

xlApp.Range(MyRange).Value = 34

How can i get the value from a range somewhere in the workbook. You shouldn't have to know what sheet it is on. You don't have to in Excel.

4

Hi,

Well, I think you may try the Worksheets.GetNamedRanges() method to get the named ranges and manipulate them as per your requirement. Please see the following sample code in this regard:

Dim wb As New Workbook()

Dim ranges() As Range = wb.Worksheets.GetNamedRanges()

Dim range As Range = ranges(0)

Dim value As String = range(0, 0).StringValue

For further details, please see the following document link:

Create Access and Copy Named Ranges

If you still have any queries, please do let us know. We will be happy to help you out.

Thank You & Best Regards,