How to get the address of a cell in $A$1 form

Question

I am using office JS to create a Excel Web Addin. I want to get the address of a cell in $A$1 form.

Right now I am using the address property of Excel.Range which gives the address like Sheet1!A1. How do I fetch it as Sheet1!$A$1?

Following is the code I use to load address property.

var activeCell = context.workbook.getActiveCell();
activeCell.load("address");

Convert is as in https://stackoverflow.com/questions/38821608/change-cell-reference-between-absolute-and-relative — L. Scott Johnson, Jun 12 '19 at 11:35
@L.ScottJohnson I am looking for a way to do this with Office JS, not VSTO. — Saurav Deb Purkayastha, Jun 12 '19 at 12:08

score 0 · Answer 1 · edited Jun 13 '19 at 02:15

0

You can use a regular expression to add the dollar signs before the column letters and row number.

Here's something that I think should work. Here $1 matches Sheet1!, $2 matches the column letters, $3 matches the row numbers, and $$ is to put a literal dollar sign in the result.

var res = str.replace(/(.*\!)(\D+)(\d+)/g, "$1$$$2$$$3");

edited Jun 13 '19 at 02:15

answered Jun 12 '19 at 17:27

adamk

114
1

How to get the address of a cell in $A$1 form

1 Answers1