Does someone have experience in altering Excel links in the variable table using the API?
My issue is the following: we have an assembly driven by variable from an external Excel file. These links were made using an English version of excel ==> R1C1 (Row 1, Column 1) relation.
On an other system where Dutch Excel is installed the excel notation is R1K1 (Row = Rij in Dutch and Column = Kolom in Dutch)
Hence this translation issue, the Excel links in SE do not work if a Dutch Excel version is used. Since there are also other macro's based on the dutch Excel version, i need both versions of the SE assembly (Dutch and English links).
I was thinks of changing all links in the assembly from "RxCy" to "RxKy", but i'm looking for the functions as used in the Variable rule editor, where you can alter this manually.