C#教程之C#教程之C# 将数据写入EXCEL表中

需要添加引用  Microsoft.Office.Interop.Excel

 private void WriteDataToExcel
{
            Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
            DataTable dataTable1 = this.GetTabel1();//获取表格2

            Microsoft.Office.Interop.Excel.Application excelApp;
            Microsoft.Office.Interop.Excel._Workbook workBook;
            Microsoft.Office.Interop.Excel._Worksheet workSheet;
            Microsoft.Office.Interop.Excel._Worksheet workSheet1; 
            object misValue = System.Reflection.Missing.Value;
            workBook = excelApp.Workbooks.Add(misValue);//加载模型
            
            workSheet = (Microsoft.Office.Interop.Excel._Worksheet)workBook.Sheets.get_Item(1);//第一个工作薄。

            workSheet1 = (Microsoft.Office.Interop.Excel._Worksheet)workBook.Sheets.get_Item(2);

            int rowIndex = 0;
            int colIndex = 0;
            foreach (DataRow row in dataTable.Rows)
            {
                rowIndex++;
                colIndex = 0;
                foreach (DataColumn col in dataTable.Columns)
                {
                    colIndex++;
                    workSheet.Cells[rowIndex, colIndex] = row[col.ColumnName].ToString().Trim();
                   
                }
            }

            rowIndex = 0;
            colIndex = 0;
            foreach (DataRow row in dataTable1.Rows)
            {
                rowIndex++;
                colIndex = 0;
                foreach (DataColumn col in dataTable1.Columns)
                {
                    colIndex++;
                    workSheet1.Cells[rowIndex, colIndex] = row[col.ColumnName].ToString().Trim();

                }
            }

　　　　　　　　
 　　　　　　 workSheet.Protect("MyPassword", Type.Missing, Type.Missing, Type.Missing,
                              Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                              Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                              Type.Missing, true, Type.Missing, Type.Missing);

            //保护工作表
            workSheet1.Protect("MyPassword", Type.Missing, Type.Missing, Type.Missing,
                              Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                              Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                              Type.Missing, true, Type.Missing, Type.Missing);

            /**/

            excelApp.Visible = false;

            workBook.SaveAs(@"D:\outputFormDataBase1.xls", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, misValue,
                misValue, misValue, misValue, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive,
                misValue, misValue, misValue, misValue, misValue);

            dataTable = null;

            workBook.Close(true, misValue, misValue);

            excelApp.Quit();

            PublicMethod.Kill(excelApp);//调用kill当前excel进程  
 

}    

 

有兴趣的可以看看 https://www.cnblogs.com/junshijie/p/5292087.html 这篇文章，里面有更详细如何操作EXCEL。