Spire.Spreadsheet is a powerful component to view spreadsheet. As a standalone spreadsheet class library, Spire.Spreadsheet is a companion component to Spire.XLS, which mainly focus on how to display spreadsheet.

Sun Jan 20, 2019 11:01 am

Hey,

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

GH

GHWels
 
Posts: 90
Joined: Sun Nov 23, 2014 7:22 pm

Mon Jan 21, 2019 2:35 am

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
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Tue Jan 22, 2019 11:39 am

Thank you
GH

GHWels
 
Posts: 90
Joined: Sun Nov 23, 2014 7:22 pm

Wed Jan 23, 2019 1:49 am

Hi GH,

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

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.Spreadsheet