1、首先要添加Microsoft.Office.Interop.Excel的引用，在你安装的vs中有，或者直接在引用里面添加即可
2、实例代码和注释：
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.IO; using System.Reflection; using Microsoft.Office.Interop.Excel; namespace test1 { class Program { public static bool WriteXls(string filename) { //启动Excel应用程序 Microsoft.Office.Interop.Excel.Application xls = new Microsoft.Office.Interop.Excel.Application(); _Workbook book = xls.Workbooks.Add(Missing.Value); //创建一张表，一张表可以包含多个sheet //如果表已经存在，可以用下面的命令打开 //_Workbook book = xls.Workbooks.Open(filename, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); _Worksheet sheet;//定义sheet变量 xls.Visible = false;//设置Excel后台运行 xls.DisplayAlerts = false;//设置不显示确认修改提示 for (int i = 1; i < 4; i++)//循环创建并写入数据到sheet { try { sheet = (_Worksheet)book.Worksheets.get_Item(i);//获得第i个sheet，准备写入 } catch (Exception ex)//不存在就增加一个sheet { sheet = (_Worksheet)book.Worksheets.Add(Missing.Value, book.Worksheets[book.Sheets.Count], 1, Missing.Value); } sheet.Name = "第" + i.ToString() + "页";//设置当前sheet的Name for (int row = 1; row < 20; row++)//循环设置每个单元格的值 { for (int offset = 1; offset < 10; offset++) sheet.Cells[row, offset] = "( " + row.ToString() + "," + offset.ToString() + " )"; } } //将表另存为 book.SaveAs(filename, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); //如果表已经存在，直接用下面的命令保存即可 //book.Save(); book.Close(false, Missing.Value, Missing.Value);//关闭打开的表 xls.Quit();//Excel程序退出 //sheet,book,xls设置为null，防止内存泄露 sheet = null; book = null; xls = null; GC.Collect();//系统回收资源 return true; } static void Main(string[] args) { string Current; Current = Directory.GetCurrentDirectory();//获取当前根目录 WriteXls(Current + "\\test.xls"); } /* static void Main(string[] args) { StreamWriter sw = new StreamWriter("f:\\C#\\temp4.txt", true, Encoding.GetEncoding("gb2312")); string data = "hello world"; sw.WriteLine(data); int[] a = {1,2,3,4,5,6}; sw.WriteLine(a.Length); for(int i=0;i<a.Length;i++) { sw.WriteLine(a[i]); } */ //sw.Close(); /* while (true) { string email, email0 = "请输入你的电子邮箱"; Console.WriteLine(email0); email = Console.ReadLine(); sw.WriteLine(email0); sw.WriteLine(email); Console.WriteLine("你的邮箱是{0}", email); Console.WriteLine("继续输入邮箱吗？"); string input = Console.ReadLine(); sw.WriteLine(input); if (input.ToUpper() == "YES") continue; else break; } */ // sw.Close(); //} } } 注释掉的内容不用管，只要引用正确，程序可以直接运行，运行结果如下：
