Create Excel(.XLS and .XLSX) File from C# using Excellibrary in Window Application

using System.IO;

using System.Text;

namespace First_Csharp_app

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void Button1_click(object sender, EventArgs e)

{

//create new xls file string file = "newdoc.xls"; Workbook workbook = new Workbook(); Worksheet worksheet = new Worksheet("First Sheet"); worksheet.Cells[0, 1] = new Cell((short)1); worksheet.Cells[2, 0] = new Cell(9999999); worksheet.Cells[3, 3] = new Cell((decimal)3.45); worksheet.Cells[2, 2] = new Cell("Text string"); worksheet.Cells[2, 4] = new Cell("Second string"); worksheet.Cells[4, 0] = new Cell(32764.5, "#,##0.00"); worksheet.Cells[5, 1] = new Cell(DateTime.Now, @"YYYY\-MM\-DD"); worksheet.Cells.ColumnWidth[0, 1] = 3000; workbook.Worksheets.Add(worksheet); workbook.Save(file); // open xls file Workbook book = Workbook.Load(file); Worksheet sheet = book.Worksheets[0];

}

}

}

Step 4: Run

Now Run your application and you will see excel file like this.

You can go on blog_munesh