C# ExcelPackage 导出数据为excel （自定义）

                         datatable dt=你的要导出的数据 

                         SaveFileDialog sfg = new SaveFileDialog();
                        //Excel文件名
                        sfg.FileName = "送货单" + DateTime.Now.ToString("yyyyMMddHHmmss");
                        sfg.Title = "导出到文件";
                        sfg.Filter = "Excel 表格|*.xlsx";
                        if (sfg.ShowDialog() == DialogResult.OK)
                        {
                            ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
                            using (FileStream fileStream = new FileStream(sfg.FileName, FileMode.Create))
                            using (ExcelPackage package = new ExcelPackage(fileStream))
                           {
                                var sheet = package.Workbook.Worksheets.Add("木屋");//添加一个sheet
                                var cells = sheet.Cells;
                                cells[1, 1].Value = "大大怪将军的小木屋";//给第一行第一列赋值
                                cells["A1:I1"].Style.Font.Bold = true; //指定区域设置字体加粗
                                cells["A1:I1"].Style.Font.Size = 18; //指定区域设置字体加粗
                                cells["A1:I1"].Merge = true;//将A列1行和I列1行的单元格合并
                                //列自适应宽度
                                sheet.Cells.AutoFitColumns();
                                //列文本水平居中显示
                                sheet.Cells.Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
                                package.Save();//保存
                           }
                         }