public void generateExcel()
{
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using (ExcelPackage excel = new ExcelPackage())
{
excel.Workbook.Worksheets.Add("Worksheet1");
excel.Workbook.Worksheets.Add("Worksheet2");
excel.Workbook.Worksheets.Add("Worksheet3");
var data = databaseHandling.generateListFromDatabase();
var headerRow = new List <string[]>()
{
new string[] { "Type", "Name", "IdCode", "Layer", "TopBottom", "Defect", "Input1", "Input2", "Decision", "Date" }
};
string headerRange = "A1:" + Char.ConvertFromUtf32(headerRow[0].Length + 64) + "1";
string borderRange = "A1:" + Char.ConvertFromUtf32(headerRow[0].Length + 64) + (data.Count + 1).ToString();
var worksheet = excel.Workbook.Worksheets["Worksheet1"];
setExcelStyle(worksheet, headerRange, borderRange);
worksheet.Cells[headerRange].LoadFromArrays(headerRow);
worksheet.Cells[2, 1].LoadFromArrays(data);
var dir = Directory.GetDirectoryRoot(Directory.GetCurrentDirectory()) + "TechnoProb1";
FileInfo excelFile = new FileInfo(dir + "\\FinalWashing.xlsx");
excel.SaveAs(excelFile);
}
}
