static void CreateWorkReport() { var period = new WorkReport(); period.InitDays(new DateTime(2016, 12, 24), new DateTime(2017, 1, 2)); using (var writer = new ExcelWriter()) { for (int i = 0; i < SHEETS; ++i) { var sheetName = string.Format("Project {0:D4}", i); writer.AddSheet(sheetName, pageLayoutView: true); writer.SetWorkSheetStyles(9); writer.SetHeaderText( null, writer.GetHeaderFooterText(20, sheetName), writer.GetPageNumOfTotalText(8) ); writer.SetMargins(0.25M, 0.75M); writer.SetColumnWidth(WorkReport.ColumnAvail, 13); writer.SetColumnWidth(WorkReport.ColumnReason, 27); writer.SetColumnWidth(WorkReport.ColumnShiftLength, 8); writer.SetColumnWidth(WorkReport.ColumnShiftName, 8); // set date header column widths int hoursStartColumn = WorkReport.ColumnShiftName + 1; int hoursEndColumn = hoursStartColumn + period.DayNames.Count; for (int col = hoursStartColumn; col < hoursEndColumn; ++col) { writer.SetColumnWidth(col, 5); } period.WriteProjectHeadingRow(writer, 1, hoursStartColumn); var testData = new List <int>(); for (int j = 1; j < 21; ++j) { testData.Add(j); } period.WriteRequestData(writer, 2, hoursStartColumn, testData); } File.WriteAllBytes( Path.Combine(BASE_DIRECTORY, "epplus-test-work.xlsx"), writer.GetAllBytes() ); } }
static void CreateSimpleReport() { // [1] create writer using (var writer = new ExcelWriter()) { var sheetCount = 0; var cellValue = 0; writer.FormatAsTable = true; do { // [2] add worksheet to workbook w/optional parameters. put code from // here to step [5], **BEFORE** the writer.GetAllBytes() call in a // repeating block to write more than one sheet writer.AddSheet( string.Format("Sheet-{0}", sheetCount), 8D ); // [3] setup worksheet (ALL CALLS OPTIONAL, AND IN ANY ORDER) // set default font size writer.SetWorkSheetStyles(9); writer.SetHeaderText( writer.GetHeaderFooterText(10, "Left"), writer.GetHeaderFooterText(20, "Center", "red"), "Right" ); writer.SetFooterText( null, writer.GetPageNumOfTotalText(8), null ); writer.SetMargins(0.25M, 0.75M); // [4] write to current worksheet: 1-based index row and column // coordinates in **ANY** order. // header var stop = 10; var cell = new Cell() { AllBorders = true, Bold = true, HorizontalAlignment = CellAlignment.HorizontalCenter }; for (var i = 1; i < stop; ++i) { cell.Value = string.Format("H{0}", i); writer.WriteCell(1, i, cell); } // data cell = new Cell() { AllBorders = true, Bold = true }; for (int i = 2; i < stop; ++i) { for (int j = 1; j < stop; ++j) { cell.Value = ++cellValue; writer.WriteCell(i, j, cell); } } } while (++sheetCount < 4); // [5] write workbook File.WriteAllBytes( Path.Combine(BASE_DIRECTORY, "epplus-test-simple.xlsx"), writer.GetAllBytes() ); } }