C#在excel中写入数据

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();
            
        //}
    }
}

注释掉的内容不用管，只要引用正确，程序可以直接运行，运行结果如下：