CODEWITHSUNDEEP
exceltypesformula
Armin Khodaei
Armin Khodaei

Reputation: 141

Change Excel Formula Type to R1C1

I want use Application.Convertformula in C# to get R1C1 Type. And Addressing with R1C1 format.

Any one know how to use that ?

Becuase this not working ! :

Excel.Range range = xlWorkSheet.get_Range("R1C1");

Upvotes: 0

Views: 798

Answers (1)

mafafu
mafafu

Reputation: 1266

Something like this? Excel.Range range = xlWorkSheet.Range[topLeft, bottomRight];

Not sure what API you're using, but see this article about that usage, which suggests using the Range property instead. Also note that both those expect two parameters and you're supplying only one with both references as one value. That is "R1", "C1" not "R1C1", and possibly Range["C1", "R1"] assuming that's the range you want, with the top left reference first.

Upvotes: 1

Related Questions