public void CreateJSONFile(IMyReport report)
{
report.content.RemoveAt(0);
File.WriteAllText(report.path + report.fileName + "." + report.fileExtension, JsonConvert.SerializeObject(report.content));
Console.WriteLine("JSON file created!");
}
public void CreateExcelFile(IMyReport report)
{
using (ExcelPackage excel = new ExcelPackage())
{
excel.Workbook.Worksheets.Add(report.title);
// Target a worksheet
var worksheet = excel.Workbook.Worksheets[report.title];
// Determine the header range (e.g. A1:D1)
string headerRange = "A1:" + Char.ConvertFromUtf32(report.content[0].Length + 64) + "1";
worksheet.Cells[headerRange].Style.Font.Bold = true;
worksheet.Cells[headerRange].Style.Font.Size = 14;
worksheet.Cells[headerRange].Style.Font.Color.SetColor(System.Drawing.Color.DarkOliveGreen);
worksheet.Cells[headerRange].Style.Locked = true;
// Popular header row data
worksheet.Cells[headerRange].LoadFromArrays(report.content);
for (int c = 10; c <= 11; c++)
{
for (int l = 2; l <= report.content.Count; l++)
{
string temp = worksheet.Cells[l, c].Text;
worksheet.Cells[l, c].Hyperlink = new ExcelHyperLink(worksheet.Cells[l, c].Text);
worksheet.Cells[l, c].Value = temp;
}
}
worksheet.Cells[2, 10, report.content.Count, 11].Style.Font.Color.SetColor(System.Drawing.Color.Blue);
worksheet.Cells[2, 10, report.content.Count, 11].Style.Font.UnderLine = true;
worksheet.Cells.Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
worksheet.Cells.Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells.Style.WrapText = true;
FileInfo excelFile = new FileInfo(report.path + report.fileName + "." + report.fileExtension);
excel.SaveAs(excelFile);
Console.WriteLine("Excel file created!");
}
}
public ReportService()
{
openOffice = new OpenOffice();
report = new MyReport();
}
