C#快速便捷导出Excel

本文主要讲解使用EPPlus来快速方便的导出数据到Excel

一：首先下载EPPlus相关链接：官方下载页

然后解压将得到的EPPlus.dll加入引用

到这里我们的准备工作就做完了，下面开始使用

二：引入命名空间

using OfficeOpenXml;

 public static void Explored()        {

    //先打开文件保存对话框，选择保存路径            SaveFileDialog sfDialog = new SaveFileDialog();            sfDialog.Title = "导出成Excel";            sfDialog.Filter = "导出Excel(*.xlsx)|*.xlsx";            sfDialog.InitialDirectory = "Bill/";            if (sfDialog.ShowDialog() == DialogResult.OK)            {                FileInfo fi = new FileInfo(sfDialog.FileName);                using (ExcelPackage excel = new ExcelPackage(fi))                {                    var ws = excel.Workbook.Worksheets.Add("账单");

    //cells的[0,0]行和列都是被占用的，不能设置，所以直接从[1,1]开始                    ws.Cells[1, 1].Value = "金额";                    ws.Cells[1, 2].Value = "日期";                    ws.Cells[1, 3].Value = "时间";                    ws.Cells[1, 4].Value = "备注";

    //设置自动根据行数据调整长度                    ws.Cells.Style.ShrinkToFit = true;                    for (int i = 2; i <= BillList.Count + 1; i++)                    {                        if (BillList[i - 2].type == Model.Bill.ComingOrSpending.Coming)                            ws.Cells[i, 1].Value = "+" + BillList[i - 2].money;                        else                            ws.Cells[i, 1].Value = "-" + BillList[i - 2].money;                        ws.Cells[i, 2].Value = BillList[i - 2].day;                        ws.Cells[i, 3].Value = BillList[i - 2].time;                        ws.Cells[i, 4].Value = BillList[i - 2].note;                    }

    //记得保存文件                    excel.Save();                }            }            MessageBox.Show("导出成功");        }