C# Export to Excel

Friday, 10 December 2010 12:09

typemissing-wscells[j-int-microsoftofficeinteropexcelapplication-new

// Assumptions
// ResultsCollection is a List contains tab delimited strings
// ExcelSaveLocation is a Property storing new file path



public void ExportToExcel()

        {

            Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();

            app.Visible = true;

            Microsoft.Office.Interop.Excel.Workbook wb = app.Workbooks.Add(1);

            Microsoft.Office.Interop.Excel.Worksheet ws = (Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets[1];

            int i = 1;

            int j = 1;

            foreach (string line in ResultsCollection)

            {

                i = 1;

                string[] r = line.Split('\t');

                ws.Cells[j, i] = r[0];

                i = i + 1;

                ws.Cells[j, i] = r[1];

                j++;

            }

            wb.SaveAs(ExcelSaveLocation, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

            wb.Close(true, Type.Missing, Type.Missing);

            app.Quit();

        }