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