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.

Thu Oct 18, 2018 10:29 am

Hey

Is it possible to :shock: get the row and col of a named area.

sincerly
GH

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

Thu Oct 18, 2018 12:36 pm

Hello,

Thanks for your inquiry.
Our Spire.Spreadsheet doesn't support getting rows/columns of named range. However, the function is well supported in our Spire.XLS. Please refer to the following code. If there is any question, welcome to write back.
Code: Select all
Workbook wb = new Workbook();
wb.LoadFromFile(filepath);
INamedRange NamedRange1 = wb.NameRanges.GetByName("MyNamedRange");
IXLSRange[] rows = NamedRange1.RefersToRange.Rows;
IXLSRange[] columns = NamedRange1.RefersToRange.Columns;

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 968
Joined: Tue Sep 27, 2016 1:06 am

Fri Oct 19, 2018 9:46 am

Thanks for your quick response.
It works perfekt
GH

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

Fri Oct 19, 2018 9:55 am

Hi,

Thanks for your feedback.
If you need further assistance, please do not hesitate to contact us.
Wish you all the best!

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 968
Joined: Tue Sep 27, 2016 1:06 am

Return to Spire.Spreadsheet