Hi,
I have a question , how to add a conditional formula to a cell in the excel document?
I would like to add a formula '=IF(H7>0,(IF(F7 > 0,(H7-F7)/F7,"")),"")' to a cell 'J7'. Can I get help for this scenario in C#.
Thankyou,
Ajeesh
Workbook workbook = new Workbook();
Worksheet worksheet=workbook.Worksheets[0];
string f = @"=IF(H7>0,(IF(F7 > 0,(H7-F7)/F7,"""")),"""")";
worksheet.Range["J7"].Formula = f;
worksheet.Range["F7"].NumberValue = 5;
worksheet.Range["H7"].NumberValue = 4;
workbook.SaveToFile("sample.xlsx",ExcelVersion.Version2007);