Cannot read named cell added with Add-ExcelName

[feardamhan]

Perhaps I’m doing something wrong but after I add a named cell it doesn’t seem like I can read it back afterward.

When I open the file in excel the name has been applied to the cell and the value I placed in it is there but when I do

$workbook.workbook.names[“added_name”] I get nothing back.

Names added manually in excel can be retrieved fine this way

Is this a bug?

[dfinke]

pls post a short repro of this

[feardamhan]

Hope this helps

Basic file before manipulation via PS (One sheet, one named cell)

Commands issued:

Cannot access the named cell

But if I open the file I can see this:

[scriptingstudio]

EPPlus does not update app.xml file in openxml definition, that's why Excel can see ps_created_name range name which is present in workbook.xml file, but EPPlus cannot. This is definitely a bug that cannot be fixed in simple way. Also EPPlus cannot set a range name scope.

UPDATE

If you create all range names programmatically a folder docProps is not created at all

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.