DoddleReport

 

 public class ExcelReportWriter : IReportWriter

中自定义Sheet名字

report.RenderHints["SheetName"] = "Test Sheet";

 

var sheetName = report.RenderHints[SheetName] as string ?? "Data";

 

 

 

 private void WriteReport(Report report, XLWorkbook workbook)
        {
            var sheetName = report.RenderHints[SheetName] as string ?? "Data";//需要传入，否则默认
            IXLWorksheet worksheet;
            int duplicateNameCount = 0;
            var originalSheetName = sheetName;
            while (workbook.Worksheets.TryGetWorksheet(sheetName, out worksheet))//判断是否有这个sheet
            {
                sheetName = originalSheetName + ++duplicateNameCount;
            }

            worksheet = workbook.Worksheets.Add(sheetName);
            worksheet.SetShowRowColHeaders(true);
            var orientation = report.RenderHints.Orientation == ReportOrientation.Portrait ? XLPageOrientation.Portrait : XLPageOrientation.Landscape;
            worksheet.PageSetup.PageOrientation = orientation;

            // Set the paper size to what the render hint is set to
            if (report.RenderHints[PaperSize] != null)
            {
                worksheet.PageSetup.PaperSize = (XLPaperSize)Enum.Parse(typeof(XLPaperSize), report.RenderHints[PaperSize].ToString());
            }

            if (report.RenderHints.FreezePanes)
                worksheet.SheetView.Freeze(report.RenderHints.FreezeRows, report.RenderHints.FreezeColumns);

            // Render the header
            var fieldsCount = report.DataFields.Count(f => !f.Hidden);
            int rowCount = RenderHeader(worksheet, fieldsCount, report.TextFields, report.RenderHints);

            // Render all the rows
            foreach (var row in report.GetRows())
            {
                rowCount++;
                var dataRow = worksheet.Row(rowCount);
                RenderRow(rowCount, row, dataRow);
            }

            // Render the footer
            RenderFooter(worksheet, fieldsCount, report.TextFields, report.RenderHints, rowCount);


            // TODO: AdjustToContents renders horribly when deployed to an Azure Website, need to determine why

            // Adjust the width of all the columns
            for (int i = 0; i < fieldsCount; i++)
            {
                var reportField = report.DataFields.Where(f => !f.Hidden).Skip(i).Take(1).Single();
                var width = new int[] { reportField.DataStyle.Width, reportField.FooterStyle.Width, reportField.HeaderStyle.Width }.Max();
                var adjustToContents = report.RenderHints[AdjustColumnWidthToContents] as bool? ?? true;

                if (adjustToContents || width > 0)
                {
                    var column = worksheet.Column(i + 1);
                    if (adjustToContents && width > 0)
                    {
                        column.AdjustToContents(width.PixelsToUnits(column.Style.Font), double.MaxValue);
                    }
                    else if (adjustToContents)
                    {
                        column.AdjustToContents(1, 50, 5.0, 100.0);
                    }
                    else
                    {
                        column.Width = width.PixelsToUnits(column.Style.Font);
                    }
                }
            }

            worksheet.Columns().AdjustToContents();

            // Check if the current writer needs to append another report to the report we just generated
            if (ReportsToAppend.ContainsKey(report))
            {
                foreach (var reportToAppend in ReportsToAppend[report])
                {
                    WriteReport(reportToAppend, workbook);
                }
            }
        }