Tuesday, 21 February 2012

Create excel spreadsheet with C#

* Download EPPlus library http://epplus.codeplex.com/

[Test]
public void Test()
{
    var file = @"Sample.xlsx";
    if (File.Exists(file)) File.Delete(file);
    using (var excel = new ExcelPackage(new FileInfo(file)))
    {
        var ws = excel.Workbook.Worksheets.Add("Sheet1");
        ws.Cells[1, 1].Value = "Date";
        ws.Cells[1, 2].Value = "Price";
        ws.Cells[1, 3].Value = "Volume";
        var random = new Random();
        for (int i = 0; i < 10; i++)
        {
            ws.Cells[i + 2, 1].Value = DateTime.Today.AddDays(i);
            ws.Cells[i + 2, 2].Value = random.NextDouble() * 1e3;
            ws.Cells[i + 2, 3].Value = random.Next() / 1e3;
        }
                    
        ws.Cells[2, 1, 11, 1].Style.Numberformat.Format = "dd/MM/yyyy";
        ws.Cells[2, 2, 11, 2].Style.Numberformat.Format = "#,##0.000000";                
        ws.Cells[2, 3, 11, 3].Style.Numberformat.Format = "#,##0";                
        ws.Column(1).AutoFit();
        ws.Column(2).AutoFit();
        ws.Column(3).AutoFit();
        excel.Save();
    }
}

excel

1 comment:

Zarfishan Zahid said...

To avoid the coding and handling the errors you can use this Excel Component in C# which not only allow you to create excel file in c#, .net, vb.net but also you can read and convert your excel files to many other formats.

Post a Comment