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?
Hello Satyala,
Let me know if you have any further questions on this matter.
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.