0
votes

create a function that will increment the excel sheet reference using JavaScript.

I have the string values that contains the excel sheet formulas and i need to increment these reference using JavaScript. Here is an example of what i am trying to achieve

Example 1

const str1 = "$A$1+1"

and the result will be

["$A$1+1", "$A$2+1", "$A$3+1", "$A$3+1"]

example 2

const str2 = "$A$10+$B$9"

result

 ["$A$10+$B$9", "$A$11+$B$10", "$A$12+$B$11", "$A$13+$B$12"]