private uint MaximumExport(SimulationResult result, SheetData sheetData, uint last_row_index) { Row max_senate_row = new Row() { RowIndex = last_row_index, Spans = new ListValue <StringValue>() }; Cell title_cell = new Cell() { CellReference = "A" + last_row_index, DataType = CellValues.String, StyleIndex = (UInt32Value)1U, CellValue = new CellValue("MAXIMUM") }; max_senate_row.Append(title_cell); uint senate_column_index = 2; foreach (var item in GetMaximum(result.Data)) { string cellname = GetExcelColumnName(senate_column_index); var data_cell = new Cell() { CellReference = cellname + last_row_index, //zacne od B DataType = CellValues.Number, StyleIndex = (UInt32Value)5U, CellValue = new CellValue(Convert.ToString(item)) }; max_senate_row.Append(data_cell); senate_column_index++; } sheetData.Append(max_senate_row); return(last_row_index); }
/* Ostatní metody jsou pouze metody pro generování výsledků do souboru. * Každá z metod zapisuje příslušné části reportu. * Zápis se provádí na úrovni buněk a řádků * */ private uint StdevExport(SimulationResult result, SheetData sheetData, uint last_row_index) { Row avg_senate_row = new Row() { RowIndex = last_row_index, Spans = new ListValue <StringValue>() }; Cell title_cell = new Cell() { CellReference = "A" + last_row_index, DataType = CellValues.String, StyleIndex = (UInt32Value)1U, CellValue = new CellValue("STDEV") }; avg_senate_row.Append(title_cell); uint senate_column_index = 2; foreach (var item in GetStdev(result.Data)) { string cellname = GetExcelColumnName(senate_column_index); var data_cell = new Cell() { CellReference = cellname + last_row_index, //zacne od B DataType = CellValues.Number, StyleIndex = (UInt32Value)7U, //dve des mista-styl7 CellValue = new CellValue(Convert.ToString(item, CultureInfo.InvariantCulture)) }; avg_senate_row.Append(data_cell); senate_column_index++; } sheetData.Append(avg_senate_row); return(last_row_index); }
private void SimulationParamsExport(List <AlgorithmInfo> ainfo, SimulationParams spar, SimulationResult result, SheetData sheetData) { Row title_row = new Row() { RowIndex = 1U, Spans = new ListValue <StringValue>() }; //KUB 6.3. pridano var alg_name = ConvertAlgorithmName((from a in alginfo where a.AlgorithmID == result.UsedAlgorithm.ToString() select a.AlgorithmName).First()); Cell cell = new Cell() { CellReference = "A1", DataType = CellValues.String, StyleIndex = (UInt32Value)1U, CellValue = new CellValue(alg_name /*info[result.UsedAlgorithm].AlgorithmName.Replace(":", " ") // KUB 6.3. vyjmuto a opraveno*/) }; title_row.Append(cell); cell = new Cell() { CellReference = "C1", DataType = CellValues.String, StyleIndex = (UInt32Value)5U, CellValue = new CellValue("Uživatel:" + spar.User.ID) }; title_row.Append(cell); cell = new Cell() { CellReference = "D1", DataType = CellValues.String, StyleIndex = (UInt32Value)5U, CellValue = new CellValue(DateTime.Now.ToString()) }; title_row.Append(cell); sheetData.Append(title_row); Row param_row = new Row() { RowIndex = 3U, Spans = new ListValue <StringValue>() }; cell = new Cell() { CellReference = "A3", DataType = CellValues.String, StyleIndex = (UInt32Value)1U, CellValue = new CellValue("Parametry simulace:") }; param_row.Append(cell); cell = new Cell() { CellReference = "C3", DataType = CellValues.String, StyleIndex = (UInt32Value)5U, CellValue = new CellValue("Počet senátů: " + spar.Senates.Count) }; param_row.Append(cell); cell = new Cell() { CellReference = "E3", DataType = CellValues.String, StyleIndex = (UInt32Value)5U, CellValue = new CellValue("Počet případů: " + spar.CasesToDistribution) }; param_row.Append(cell); cell = new Cell() { CellReference = "G3", DataType = CellValues.String, StyleIndex = (UInt32Value)5U, CellValue = new CellValue("Počet iterací: " + spar.IterationsCount) }; param_row.Append(cell); sheetData.Append(param_row); }
private uint SimulationResultsExport(SimulationParams spar, SimulationResult result, SheetData sheetData, uint last_row_index) { Row title_senate_row = new Row() { RowIndex = last_row_index, Spans = new ListValue <StringValue>() }; Cell title_cell = new Cell() { CellReference = "A" + last_row_index, DataType = CellValues.String, StyleIndex = (UInt32Value)4U, CellValue = new CellValue("Iterace") }; title_senate_row.Append(title_cell); uint senate_column_index = 2; foreach (var s in spar.Senates) { string cellname = GetExcelColumnName(senate_column_index); title_cell = new Cell() { CellReference = cellname + last_row_index, //zacne od B DataType = CellValues.String, StyleIndex = (UInt32Value)4U, CellValue = new CellValue(s.ID) }; senate_column_index++; title_senate_row.Append(title_cell); } sheetData.Append(title_senate_row); last_row_index++;//posun se na dalsi radek int iter_counter = 1; foreach (var iter_data in result.Data)//pro kazdou iteraci { Row data_senate_row = new Row() { RowIndex = last_row_index, Spans = new ListValue <StringValue>() }; Cell data_cell = new Cell() { CellReference = "A" + last_row_index, DataType = CellValues.Number, StyleIndex = (UInt32Value)6U, CellValue = new CellValue(Convert.ToString(iter_counter++)) }; data_senate_row.Append(data_cell); senate_column_index = 2; foreach (var item in iter_data) { string cellname = GetExcelColumnName(senate_column_index); data_cell = new Cell() { CellReference = cellname + last_row_index, //zacne od B DataType = CellValues.Number, StyleIndex = (UInt32Value)6U, CellValue = new CellValue(Convert.ToString(item)) }; senate_column_index++; data_senate_row.Append(data_cell); } sheetData.Append(data_senate_row); last_row_index++; } return(last_row_index); }