C# create excel file c# - Net-Raft.com

// check MS excel object library in Reference Manager

using System;
using System.Windows.Forms;
using System.Runtime.InteropServices;
using Excel = Microsoft.Office.Interop.Excel;

namespace WindowsFormsApplication3
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
if (xlApp == null)
{
MessageBox.Show("MS Excel is not properly installed!");
return;
}

Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlWorkBook = xlApp.Workbooks.Add(misValue); // create new Workbook
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); // sheet1

xlWorkSheet.Cells[1, 1] = "Name";
xlWorkSheet.Cells[1, 2] = "Age";
xlWorkSheet.Cells[2, 1] = "Jack";
xlWorkSheet.Cells[2, 2] = "25";
xlWorkSheet.Cells[3, 1] = "Peter";
xlWorkSheet.Cells[3, 2] = "32";

xlWorkBook.SaveAs("d:\\myexcelfile.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); // save the file
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();

Marshal.ReleaseComObject(xlWorkSheet);
Marshal.ReleaseComObject(xlWorkBook);
Marshal.ReleaseComObject(xlApp);
MessageBox.Show("MS Excel file successfully created!");

}
}
}