get the row and col of a named area

[GHWels]

Hey

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

sincerly
GH

[Nina.Tang]

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

[GHWels]

Thanks for your quick response.
It works perfekt
GH

[Nina.Tang]

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