- var workbook = new GrapeCity.Documents.Excel.Workbook();
- IWorksheet worksheet = workbook.Worksheets[0];
- worksheet.Range["N10"].Value = 0.4528;
- worksheet.Range["O10"].Value = 8;
- worksheet.Range["P10"].Value = 0.0566;
- worksheet.Range["Q10"].Value = 1;
- worksheet.Range["R10"].Value = 1;
- worksheet.Range["S10"].Formula = "=IF(Q10=0,"",IF(R10=1,(N10-(O10-1)*P10),P10))";
- Console.WriteLine(worksheet.Range["S10"].Value);
复制代码
上面是测试代码
|