send Data from table to excel

private static void Excel(string fileName, List<IDirectoryInventoryDataCollector> list)
{
    try
    {
        var xlApp = new Excel.Application();
        var xlWorkBook = xlApp.Workbooks.Add();
        var xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
        ExcelTitleRow(list[0], 1, xlWorkSheet);

        int row = 2;
        foreach (var item in list)
        {
            ExcelFillRow(item, row++, xlWorkSheet);
        }

        for (int i = 1; i < list[0].MaxLevel - 1; i++)
        {
            ((Range)xlWorkSheet.Columns[i]).ColumnWidth = 2;
        }
        ((Range)xlWorkSheet.Columns[list[0].MaxLevel - 1]).ColumnWidth = 30;
        ((Range)xlWorkSheet.Rows[1]).WrapText = true;
        ((Range)xlWorkSheet.Rows[1]).HorizontalAlignment = HorizontalAlignment.Center;
        ((Range)xlWorkSheet.Cells[1, 1]).WrapText = false;

        xlWorkBook.SaveAs(fileName);
        xlWorkBook.Close();
        xlApp.Quit();
    }
    catch (AccessViolationException)
    {
        System.Windows.Forms.MessageBox.Show(
             "Have encountered access violation. This could be issue with Excel 2000 if that is only version installed on computer",
             "Access Violation");
    }
    catch (Exception)
    {
        System.Windows.Forms.MessageBox.Show("Unknown error",
             "Unknown error");
    }
}

private static void ExcelFillRow(IDirectoryInventoryDataCollector item, int row, Excel.Worksheet sheet)
{
    sheet.Cells[row, item.Level] = item.Name;
    int column = item.MaxLevel;
    foreach (var property in item.GetProperties())
    {
        sheet.Cells[row, column++] = property;
    }
}

private static void ExcelTitleRow(IDirectoryInventoryDataCollector item, int row, Excel.Worksheet sheet)
{
    sheet.Cells[row, 1] = "Name";
    int column = item.MaxLevel;
    foreach (var property in item.GetPropertyNames())
    {
        sheet.Cells[row, column++] = property;
    }
}

Add reference  of Microsoft.Office.Interop.Excel to your application(11 version)
//include this in namespaces

using Excel = Microsoft.Office.Interop.Excel;

//dataset contains the data you want to export
//drivename means the localdiskdrive name
//foldername means in which folder you want to save the excel file
//filename is the name of excel file


public void ExportToExcel(DataSet ds, string drivename, string foldername, string filename)
        {
            if (ds.Tables[0].Rows.Count != 0)
            {
                XmlDataDocument xmlDoc = new System.Xml.XmlDataDocument(ds);
                XslCompiledTransform xslTran = new System.Xml.Xsl.XslCompiledTransform();

                //Create XmlTextWriter for the FileSteam
                //FileStream fs = new System.IO.FileStream("test.xls",FileMode.OpenOrCreate);
                DirectoryInfo di = new DirectoryInfo(drivename + ":\\" + foldername);
                if (di.Exists == false)
                    di.Create();

                FileStream fs = new System.IO.FileStream(drivename + ":\\" + foldername + "\\" + filename + ".xls", FileMode.OpenOrCreate);

                XmlTextWriter xtw = new System.Xml.XmlTextWriter(fs, System.Text.Encoding.Unicode);

                //Add processing instructions to the beginning of the XML file,X
                // one of which indicates a style sheet.
                xtw.WriteProcessingInstruction("xml", "version='1.0'");
                string strXSLFilename;
                strXSLFilename = "test.xsl";
                xtw.WriteProcessingInstruction("xml-stylesheet", "type='text/xls' href='" + strXSLFilename + "'");

                //Write the XML from the dataset to the file
                ds.WriteXml(xtw);
                xtw.Close();
                MessageBox.Show("Successfully exported to Excel sheet please verify" + drivename + ":\\" + foldername + "\\", "Export");

            }
            else
            {
                MessageBox.Show("No Records found to Export.", "Warning");
            }


        }