Mon Feb 12, 2018 10:25 am
Dear Team,
Kindly find the below code snippet
using System.Drawing;
using Spire.Xls;
using System;
using System.Globalization;
namespace Create_Excel_File
{
class Program
{
static void Main(string[] args)
{
DateTime setl = Convert.ToDateTime("2017-12-30");
DateTime mat = Convert.ToDateTime("2018-08-30");
double cpn = Convert.ToDouble((Convert.ToDecimal(12) / 100));//copRate
double yld = Convert.ToDouble((Convert.ToDecimal(11.95) / 100));
//Initialize a new Workboook object
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xls");
//Get the first worksheet
Worksheet sheet = workbook.Worksheets[0];
//Write string values in a cell
sheet.Range["A1"].Value2 = new DateTime(2017, 12, 30);
sheet.Range["A1"].NumberFormat = "dd/mm/yyyy";
sheet.Range["A2"].Value2 = new DateTime(2018, 08, 30);
sheet.Range["A2"].NumberFormat = "dd/mm/yyyy";
sheet.Range["A3"].NumberValue = cpn;
sheet.Range["A4"].NumberValue = yld;
sheet.Range["A5"].NumberValue = 100;
sheet.Range["A6"].NumberValue = 2;
sheet.Range["A7"].NumberValue = 1;
try
{
workbook.CalculateAllValue();
Console.WriteLine(workbook.ActiveSheet.GetFormulaNumberValue(8,1));
}
catch (Exception ex) {
throw new Exception(ex.Message);
}
}
}
}
i got Nan output.
Regards,
Syed Salahuddin
- Attachments
-
- Sample.7z
- attached my excel file
- (4.9 KiB) Downloaded 227 times