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