Get NamedRanges

[GHWels]

Hey,

is it possibe to get a namedRange in Spreadsheet and the adresse of the range?

GH

[Betsy.jiang]

Hi GH,

Thanks for your inquiry.
Please refer to following code:

Code: Select all

            Spire.Spreadsheet.Forms.INamedRange nameRange = spreadsheet1.NamedRanges["name"];
            var Naddress = nameRange.RefersTo;

Sincerely,
Betsy
E-iceblue support team

[GHWels]

Thank you
GH

[Betsy.jiang]

Hi GH,

Please feel free to contact us if you need any help.

Sincerely,
Betsy
E-iceblue support team