Excel named cell ? #444

New Issue

2016-07-19T19:25:41Z

ghost commented

2016-07-19 19:25:41 +00:00

(Migrated from github.com)

Is it possible to get an Excel named cell ?

Currently, to access to cell A1, we use :
worksheet['A1']

In my case, I want to access to a cell which has a name as 'myNamedCell' as :
worksheet['myNamedCell']

But it does not work. It returns undefined.

Is there another way to get a named cell ?

Is it possible to get an Excel named cell ? Currently, to access to cell A1, we use : worksheet['A1'] In my case, I want to access to a cell which has a name as 'myNamedCell' as : worksheet['myNamedCell'] But it does not work. It returns undefined. Is there another way to get a named cell ?

SheetJSDev commented

2020-03-02 07:12:40 +00:00

(Migrated from github.com)

Defined names are extracted, as explained in the docs

You can walk that array to find the range for a given defined name, then walk the worksheet to get the individual cells

Defined names are extracted, [as explained in the docs](https://docs.sheetjs.com/#defined-names) You can walk that array to find the range for a given defined name, then walk the worksheet to get the individual cells

amirhosseinlookcle commented

2022-01-02 08:57:14 +00:00

(Migrated from github.com)

Hi
How can I walk the worksheet with the format given in the object of defined names; the "ref" is written this way "Ref: 'Sheet1!$E$3:$E$5'" and I do not know how to convert it to a format to be read and even how to read it.
Thanks

Hi How can I walk the worksheet with the format given in the object of defined names; the "ref" is written this way "Ref: 'Sheet1!$E$3:$E$5'" and I do not know how to convert it to a format to be read and even how to read it. Thanks

Sign in to join this conversation.