//public static void Create()
//{
// ////create new xls file
// //string file = "C:\\newdoc.xls";
// ////Workbook workbook = new Workbook();
// ////Worksheet worksheet = new Worksheet("First Sheet");
// ////worksheet.Cells[0, 1] = new Cell((short)1);
// ////worksheet.Cells[2, 0] = new Cell(9999999);
// ////worksheet.Cells[3, 3] = new Cell((decimal)3.45);
// ////worksheet.Cells[2, 2] = new Cell("Text string");
// ////worksheet.Cells[2, 4] = new Cell("Second string");
// ////worksheet.Cells[4, 0] = new Cell(32764.5, "#,##0.00");
// ////worksheet.Cells[5, 1] = new Cell(DateTime.Now, @"YYYY\-MM\-DD");
// ////worksheet.Cells.ColumnWidth[0, 1] = 3000;
// ////workbook.Worksheets.Add(worksheet);
// ////workbook.Save(file);
// ////// open xls file
// ////Workbook book = Workbook.Load(file);
// ////Worksheet sheet = book.Worksheets[0];
// //var wb = new XLWorkbook();
// //var ws = wb.Worksheets.Add("Contacts");
// //// Title
// //ws.Cell("B2").Value = "Contacts";
// //// First Names
// //ws.Cell("B3").Value = "FName";
// //ws.Cell("B4").Value = "John";
// //ws.Cell("B5").Value = "Hank";
// //ws.Cell("B6").Value = "Dagny";
// //// Last Names
// //ws.Cell("C3").Value = "LName";
// //ws.Cell("C4").Value = "Galt";
// //ws.Cell("C5").Value = "Rearden";
// //ws.Cell("C6").Value = "Taggart";
// //// Boolean
// //ws.Cell("D3").Value = "Outcast";
// //ws.Cell("D4").Value = true;
// //ws.Cell("D5").Value = false;
// //ws.Cell("D6").Value = false;
// //// DateTime
// //ws.Cell("E3").Value = "DOB";
// //ws.Cell("E4").Value = new DateTime(1919, 1, 21);
// //ws.Cell("E5").Value = new DateTime(1907, 3, 4);
// //ws.Cell("E6").Value = new DateTime(1921, 12, 15);
// //// Numeric
// //ws.Cell("F3").Value = "Income";
// //ws.Cell("F4").Value = 2000;
// //ws.Cell("F5").Value = 40000;
// //ws.Cell("F6").Value = 10000;
// //// From worksheet
// //var rngTable = ws.Range("B2:F6");
// //// From another range
// //var rngDates = rngTable.Range("D3:D5"); // The address is relative to rngTable (NOT the worksheet)
// //var rngNumbers = rngTable.Range("E3:E5"); // The address is relative to rngTable (NOT the worksheet)
// //// Using OpenXML's predefined formats
// //rngDates.Style.NumberFormat.NumberFormatId = 15;
// //// Using a custom format
// //rngNumbers.Style.NumberFormat.Format = "$ #,##0";
// //var rngHeaders = rngTable.Range("A2:E2"); // The address is relative to rngTable (NOT the worksheet)
// //rngHeaders.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
// //rngHeaders.Style.Font.Bold = true;
// //rngHeaders.Style.Fill.BackgroundColor = XLColor.Aqua;
// //rngTable.Style.Border.BottomBorder = XLBorderStyleValues.Thin;
// //rngTable.Cell(1, 1).Style.Font.Bold = true;
// //rngTable.Cell(1, 1).Style.Fill.BackgroundColor = XLColor.CornflowerBlue;
// //rngTable.Cell(1, 1).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
// //rngTable.Row(1).Merge(); // We could've also used: rngTable.Range("A1:E1").Merge()
// ////Add a thick outside border
// //rngTable.Style.Border.OutsideBorder = XLBorderStyleValues.Thick;
// //// You can also specify the border for each side with:
// //// rngTable.FirstColumn().Style.Border.LeftBorder = XLBorderStyleValues.Thick;
// //// rngTable.LastColumn().Style.Border.RightBorder = XLBorderStyleValues.Thick;
// //// rngTable.FirstRow().Style.Border.TopBorder = XLBorderStyleValues.Thick;
// //// rngTable.LastRow().Style.Border.BottomBorder = XLBorderStyleValues.Thick;
// //ws.Columns(2, 6).AdjustToContents();
// //wb.SaveAs("BasicTable.xlsx");
// //CreateResult();
//}
public static void CreateResult(ExcelModel model, bool needToSave = true)
{
model.SetMeltsOxides();
Model = model;
var disk = AppDomain.CurrentDomain.BaseDirectory.ToCharArray().First();
string fileName = string.Format(@"{1}:\result{0}.xlsx", DateTime.Now.ToString("dd-MM-yy_hhmm"), disk);
string template = "template.xlsx";
var wb = new XLWorkbook(template);
var ws = wb.Worksheet("result");
CreateHeader(ws);
SetRows(ws);
SetData(ws);
wb.SaveAs(fileName);
if (needToSave)
{
Sqlite.SaveProject(Model);
}
Model = null;
}
public static void SaveProject(ExcelModel model)
{
IDbConnection db = dbFactory.OpenDbConnection();
db.Save(new Project() { Model = model });
}
private void SaveExcelResult()
{
var excelModel = new ExcelModel(
"New material",
this.FirstSystem.Formula,
this.SecondSystem.Formula,
this.firstOxide.Formula,
this.secondOxide.Formula,
this.TemperaturesModels.Select(x => x.Temperature).ToList(),
this.Oxides.ToList(),
this.TemperaturesModels.ToList(),
this.resTemperaturesModels,
this.firstModule,
this.secondModule,
this.oxidesResultModels,
this.FirstSystem,
this.SecondSystem,
this.sumR2O);
ExcelCreator.CreateResult(excelModel);
}