C# 往excel出力数据

  /// <summary>
  /// 出力Excel
  /// </summary>
  /// <param name="storeModelForExcel"></param>
  public void GenerateExcel(List<ExcelModel> excelModelList,string savePath)
  {
      Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
      if (excel == null)
      {
          return;
      }
      //设置为不可见，操作在后台执行，为 true 的话会打开 Excel
      excel.Visible = false;
      //打开时设置为全屏显式
      //excel.DisplayFullScreen = true;
      //初始化工作簿
      Microsoft.Office.Interop.Excel.Workbooks workbooks = excel.Workbooks;
      //新增加一个工作簿，Add（）方法也可以直接传入参数 true
      Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
      var tt = workbook.Worksheets.Count;
      try
      {
          for (int sheetNum = 0; sheetNum < excelModelList.Count; sheetNum++)
          {
              Microsoft.Office.Interop.Excel.Range range;
              for (int k = 0; k < tt; k++)
              {
                  //设置表的名称
                  Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[k + 1];
                  worksheet.Name = excelModelList[sheetNum].dt.TableName;
                  range = worksheet.get_Range("A1", System.Reflection.Missing.Value);
                  range.NumberFormat = "@";
                  range = range.get_Resize(excelModelList[sheetNum].dt.Rows.Count + 1, excelModelList[sheetNum].dt.Columns.Count);
                  string[,] saRet = new string[excelModelList[sheetNum].dt.Rows.Count + 1, excelModelList[sheetNum].dt.Columns.Count];
                  //设置列名
                  for (int i = 0; i < excelModelList[sheetNum].dt.Columns.Count; i++)
                  {
                      //设置第一行，即列名
                      saRet[0, i] = excelModelList[sheetNum].dt.Columns[i].ColumnName;
                  }
                  //跳过第一行，第一行写入了列名
                  int rowIndex = 1;
                  //写入数据
                  for (int i = 0; i < excelModelList[sheetNum].dt.Rows.Count; i++)
                  {
                      for (int j = 0; j < excelModelList[sheetNum].dt.Columns.Count; j++)
                      {
                          saRet[rowIndex + i, j] = excelModelList[sheetNum].dt.Rows[i][j].ToString();
                      }
                  }
                  range.set_Value(System.Reflection.Missing.Value, saRet);
                  //设置所有列宽为自动列宽
                  //worksheet.Columns.AutoFit();
                  //设置所有单元格列宽为自动列宽
                  worksheet.Cells.Columns.AutoFit();
              }
              //新增加一个 Excel 表(sheet)
              if (sheetNum < excelModelList.Count - 1)
              {
                  workbook.Worksheets.Add();
              }
          }
          //是否提示，如果想删除某个sheet页，首先要将此项设为fasle。
          excel.DisplayAlerts = false;
          //保存写入的数据，这里还没有保存到磁盘
          workbook.Saved = true;
          ////创建文件
          FileStream file = new FileStream(savePath, FileMode.CreateNew);
          //关闭释放流，不然没办法写入数据
          file.Close();
          file.Dispose();
          ////保存到指定的路径
          workbook.SaveCopyAs(savePath);
          workbook.Close(Type.Missing, Type.Missing, Type.Missing);
          excel.Quit();
          //关闭进程，防止启动多个，导致内存溢出
          IntPtr t = new IntPtr(excel.Hwnd);
          int processId = 0;
          GetWindowThreadProcessId(t, out processId);
          System.Diagnostics.Process p = System.Diagnostics.Process.GetProcessById(processId);
          p.Kill();
      }
      catch (Exception e)
      {
          throw e;
      }
  }
 
  [DllImport("User32.dll", CharSet = CharSet.Auto)]
  public static extern int GetWindowThreadProcessId(IntPtr hwnd, out   int ID);

注意：数据先写到内存saRet，在一次性写进sheet

range.set_Value(System.Reflection.Missing.Value, saRet);