Identifier a cell in excel

[macahrtur]

Hello,
For our project is necessary can identifier a cell of excel (for example through a Id, tag or similar)

We are using the cell position for assign a name to one table. If add or delete a column in the sheet the cell position change and we are not able identifier the tableName.

how can we set/get a property unique for the cell?

Best Regards

[AlexJerabek]

Hi @macahrtur,
Thank you for your question. Let me do some research and get back to you soon.

[AlexJerabek]

Hi @macahrtur,

Have you tried using NamedItems? You can assign an identifier to a Range and recall it later using a unique identifier.

Here's a Script Lab snippet that shows how to track a cell that's moved in the worksheet because of a deleted column: https://gist.github.com/AlexJerabek/dad115c3361d2e17527aeb0c93900da1

Please let me know if that helps.

[macahrtur]

Thanks Alex...

We have tried use NamedItems but not able identify the name selecting the cell, we need know the nameditem selecting the cell.

We need set some property to cell, next delete row and columns. Next we need get that property selecting the cell.

Thanks

[AlexJerabek]

Thanks @macahrtur.

@lumine2008 or @keyur32, is the functionality needed here possible with the Excel APIs today?

[macahrtur]

Hello...
any news on this? We following with this issue.

Thanks

[AlexJerabek]

Hi @macahrtur,
I'll ping the product team internally for a response. In the meantime, consider posting a question on Stack Overflow, using the "office-js" tag. That will be more visible to the larger add-ins community.

[AlexJerabek]

Here's the link to the Stack Overflow question and answer: https://stackoverflow.com/questions/63039555/tracking-a-cell-in-excel-js

To reiterate what Raymond said there, there are a couple potential workarounds, but it sounds like you need a Range metadata feature that's not in the product. You can add a request on UserVoice, so others can upvote the idea and help prioritize it.

I'm going to close this issue, as there's nothing that can be done in the samples repo to help.