Excel 2010 named range collection is empty

Question

I have created an excel file (excel 2010) and set some cell names. I would like to get this name in my code with epplus lib. Worksheet has a special property for it Names but this collection is empty all the time.

var currentCell = worksheet.Cells[1, 1];

var name = worksheet.Names.SingleOrDefault(e => e.FullAddressAbsolute == currentCell.FullAddressAbsolute);

I just wonder is it issue in excel, or i need use other way to get it.

Are the names you defined in excel scoped as "workbook", or as "worksheet" ? — Tim Williams, Sep 24 '15 at 18:32

score 0 · Answer 1 · edited May 23 '17 at 11:58

0

You are probably looking in the wrong collection. Typical named ranges are actually saved in the workBOOK and not the workSHEET. See this answer:

Is there a way to get 'named' cells using EPPlus?

edited May 23 '17 at 11:58

Community

1
1

answered Sep 24 '15 at 19:10

Ernie S

13,902
4
52
79

Excel 2010 named range collection is empty

1 Answers1