Error when referring to cell by object, not directly naming cell

[datadrivensupplychain]

I'm trying out excel.link and it has the functionality I need when I'm directly referring to a cell via the command line or a script, eg xlrc[h4] <- 500 sets cell H4 to 500 (I just switch over to Excel and check). This works, but if I try to set the cell as an object (eg k <- 'H4' ) then refer to that object xlrc[k] <- 500 , I get Error: Exception Returned. I'm trying out excel.link because I need to be able to do what-if scenarios on a spreadsheet with thousands of iterations, so I need to be able to not hand-type in cell references every time! Where did I go wrong?

[gdemin]

When you want to use range in the variable you need to use double bracket notation:

xlrc[[k]] <- 500

[datadrivensupplychain]

Thank you From: Gregory Demin ***@***.***> Sent: Tuesday, October 3, 2023 2:39 AM To: gdemin/excel.link ***@***.***> Cc: datadrivensupplychain ***@***.***>; Author ***@***.***> Subject: Re: [gdemin/excel.link] Error when referring to cell by object, not directly naming cell (Issue #29) When you want to use range in the variable you need to use double bracket notation: xlrc[[k]] <- 500 — Reply to this email directly, view it on GitHub <#29 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/ASKSE6Z65SVGGJK2XJ34XP3X5O6KFAVCNFSM6AAAAAA5N7MVM2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONBUGM3TIOJVG4> . You are receiving this because you authored the thread. <https://github.com/notifications/beacon/ASKSE64R5TMR3IWZ5AFNRG3X5O6KFA5CNFSM6AAAAAA5N7MVM2WGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTTH7EGK2.gif> Message ID: ***@***.*** ***@***.***> >