EPPlus

引入EPPlus的NuGet程序包

一丶导出excel文件

static void Main(string[] args)
        {
            FileInfo newFile = new FileInfo(@"E:\test.xlsx");
            if (newFile.Exists)
            {
                newFile.Delete();
                newFile = new FileInfo(@"E:\test.xlsx");
            }
            using (ExcelPackage package = new ExcelPackage(newFile))
            {
                ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("test");
                worksheet.Cells[1, 1].Value = "名称";
                worksheet.Cells[1, 2].Value = "价格";
                worksheet.Cells[1, 3].Value = "销量";

                worksheet.Cells[2, 1].Value = "大米";
                worksheet.Cells[2, 2].Value = 56;
                worksheet.Cells[2, 3].Value = 100;

                worksheet.Cells[3, 1].Value = "玉米";
                worksheet.Cells[3, 2].Value = 45;
                worksheet.Cells[3, 3].Value = 150;

                worksheet.Cells[4, 1].Value = "小米";
                worksheet.Cells[4, 2].Value = 38;
                worksheet.Cells[4, 3].Value = 130;

                worksheet.Cells[5, 1].Value = "糯米";
                worksheet.Cells[5, 2].Value = 22;
                worksheet.Cells[5, 3].Value = 200;

                package.Save();
            }          
            Console.WriteLine("ok");
            Console.ReadLine();
        }

二丶读取excel

static void Main(string[] args)
        {
            FileInfo newFile = new FileInfo(@"E:\test.xlsx");
            if (!newFile.Exists)
            {
                return;
            }
            using (ExcelPackage package = new ExcelPackage(newFile))
            {
                //读取sheet未test1的内容
                ExcelWorksheet worksheet = package.Workbook.Worksheets["test1"];
                //ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
                //ExcelWorksheet worksheet = package.Workbook.Worksheets.First();
                string tmp = worksheet.Cells[1, 1].Text;
                Console.WriteLine(tmp);
            }
            Console.WriteLine("ok");
            Console.ReadLine();
        }        

 

参考网址：https://www.cnblogs.com/rumeng/tag/Epplus/

NPOI和EPPlus都可以对excel进行处理，他们又有着怎么区别：

https://www.cnblogs.com/tanpeng/p/6155749.html

EPPlus官网地址：https://archive.codeplex.com/?p=epplus

NPOI官网地址：https://archive.codeplex.com/?p=npoi