Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Srinivas
85
Converting excel formula from A1 to R1C1 format.
posted

I am uploading the excel file with formula's in A1 format. I want to store formula's to DB in R1C1 format. Is there any way of converting excel A1 formula format to R1C1 format?

Parents
  • 34510
    Offline posted

    Hello Satyala,

    Assuming that you are using the Infragistics Excel Library, you can get the A1 formula and get the R1C1 version by calling ToString on the WorksheetCell.Formula property.  Here is an example:

     string r1c1 = worksheet1.GetCell("D5").Formula.ToString(CellReferenceMode.R1C1);

    You can then take the R1C1 version of the formula and store it in your DB as you require.

Reply Children
No Data