或者参考NPOI

    典型错误

    https://www.crifan.com/csharp_worksheet_an_unhandled_exception_of_type_system_runtime_interopservices_comexception_occurred_in_mscorlib_dll/

    原参考资料

    http://www.cnblogs.com/fengrengui/articles/397899.html

    添加一个dll

    导出数据到excel - 图1导出数据到excel - 图2

    1. public static void ExportExcel(List<Student> dtsSelect)
    2. {
    3.     List<Student> ds = dtsSelect;//数据源
    4.     if (ds == null) return;
    5.     string saveFileName = "";
    6.     bool fileSaved = false;
    7.     SaveFileDialog saveDialog = new SaveFileDialog();
    8.     saveDialog.DefaultExt = "xls";
    9.     saveDialog.Filter = "Excel文件|*.xls";
    10.     saveDialog.FileName = "Sheet1";
    11.     saveDialog.ShowDialog();
    12.     saveFileName = saveDialog.FileName;
    13.     if (saveFileName.IndexOf(":") < 0) return; //被点了取消
    14.     Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
    15.     if (xlApp == null)
    16.                        {
    17.                            MessageBox.Show("无法创建Excel对象，可能您的机子未安装Excel");
    18.                            return;
    19.                        }
    20.     Microsoft.Office.Interop.Excel.Workbooks workbooks = xlApp.Workbooks;
    21.     Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
    22.     Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];//取得sheet1
    23.     //写入字段
    25.     //写入数值
    26.     for (int r = 1; r <=ds.Count; r++)
    27.                        {
    29.                            worksheet.Cells[r, 1] = ds[r-1].ID.ToString();
    30.                            worksheet.Cells[r, 2] = ds[r-1].Name.ToString();
    31.                            worksheet.Cells[r, 3] = ds[r-1].Age.ToString();
    32.                            System.Windows.Forms.Application.DoEvents();
    33.                        }
    34.     worksheet.Columns.EntireColumn.AutoFit();//列宽自适应。
    36.     if (saveFileName != "")
    37.                        {
    38.                            try
    39.                                {
    40.                                    workbook.Saved = true;
    41.                                    workbook.SaveCopyAs(saveFileName);
    42.                                    fileSaved = true;
    43.                                }
    44.                            catch (Exception ex)
    45.                                {
    46.                                    fileSaved = false;
    47.                                    MessageBox.Show("导出文件时出错,文件可能正被打开！\n" + ex.Message);
    48.                                }
    49.                        }
    50.     else
    51.                        {
    52.                            fileSaved = false;
    53.                        }
    54.     xlApp.Quit();
    55.     GC.Collect();//强行销毁
    56.     if (fileSaved && System.IO.File.Exists(saveFileName)) System.Diagnostics.Process.Start(saveFileName); //打开EXCEL
    57. }
    58.   }