private int GenerateTotal(int rowIndex, ISheet sheet) { rowIndex++; rowIndex++; var row13 = sheet.CreateRow(rowIndex); row13.CreateCell(0).SetCellValue("overzicht totaal"); rowIndex++; rowIndex++; var list = _calc.CalculateTotal(); foreach (var data in list) { var alpha = sheet.CreateRow(rowIndex); alpha.CreateCell(0).SetCellValue("Alpha"); alpha.CreateCell(1).SetCellValue(TotalSunHeat.CalculateRadianToDegree(data.Item1)); rowIndex++; var wandAzimuth = sheet.CreateRow(rowIndex); wandAzimuth.CreateCell(0).SetCellValue("wand azimuth"); wandAzimuth.CreateCell(1).SetCellValue(data.Item2); rowIndex++; int col_hoogte_zon = 2; var uur = sheet.CreateRow(rowIndex); uur.CreateCell(0).SetCellValue("uur"); uur.CreateCell(1).SetCellValue("uur"); rowIndex++; var Qz = sheet.CreateRow(rowIndex); Qz.CreateCell(0).SetCellValue("Qz"); Qz.CreateCell(1).SetCellValue("graden"); foreach (var yeet in data.Item3) { uur.CreateCell(col_hoogte_zon).SetCellValue(yeet.Item1); Qz.CreateCell(col_hoogte_zon).SetCellValue(yeet.Item2); col_hoogte_zon++; } rowIndex++; rowIndex++; } return(rowIndex); }
public static string FormatTotal(TotalSunHeat data) { var sb = new StringBuilder(); var listData = data.CalculateTotal(); sb.AppendLine(">>Totaal Qz1: "); foreach (var dat in listData) { var sbAwaplhaComb = new StringBuilder(); var aplh = dat.Item1; var Aw = dat.Item2; sbAwaplhaComb.AppendLine(">>aplha: " + TotalSunHeat.CalculateRadianToDegree(aplh)); sbAwaplhaComb.AppendLine(">>Aw: " + Aw); var list = dat.Item3; var sbHour = new StringBuilder(); var sbVal = new StringBuilder(); sbHour.AppendFormat("|{0,13}|", "uur"); sbVal.AppendFormat("|{0,13}|", "Qz"); foreach (var tuple in list) { sbHour.AppendFormat("|{0,8}|", +tuple.Item1); sbVal.AppendFormat("|{0,8:N2}|", tuple.Item2); } sbAwaplhaComb.AppendLine(sbHour.ToString()); sbAwaplhaComb.AppendLine(sbVal.ToString()); sbAwaplhaComb.AppendLine(); sb.Append(sbAwaplhaComb.ToString()); } sb.Append("\n"); return(sb.ToString()); }