private FormattedTable GetMainTable() { var data = this.GetMainData(); // Default sorting var view = data.DefaultView; view.Sort = data.Columns["treatment"].ColumnName; // Create formatted table var table = new FormattedTable(view.ToTable()); table.AddTableFormatting(true); // Column renaming table.AddColumnRenaming("attribute_", "ATTRIBUTE"); table.AddColumnRenaming("change_", "CHANGE"); table.AddColumnRenaming("beforeany", "YEARS BEFORE ANY TREATMENT"); table.AddColumnRenaming("beforesame", "YEARS BEFORE SAME TREATMENT"); table.AddColumnRenaming("treatmentid", "TREATMENT ID"); table.AddColumnRenaming("simulationid", "SIMULATION ID"); return(table); }
private FormattedTable GetMainTable() { var data = this.GetMainData(); // Default sorting var view = data.DefaultView; view.Sort = data.Columns["prioritylevel"].ColumnName; // Create formatted table var table = new FormattedTable(view.ToTable()); table.AddTableFormatting(true); // Column renaming table.AddColumnRenaming("prioritylevel", "PRIORITY LEVEL"); // Other formatting table.AddFormatting(new RangeFormatting( Format.Currency, 0, 2, data.Rows.Count, data.Columns.Count - 2)); return(table); }
private FormattedTable GetMainTable() { var data = this.GetMainData(); // Default sorting var view = data.DefaultView; view.Sort = data.Columns["year_"].ColumnName; // Create formatted table var table = new FormattedTable(view.ToTable()); table.AddTableFormatting(true); // Column renaming table.AddColumnRenaming("year_", "YEAR"); // Other formatting table.AddFormatting(new RangeFormatting( Format.Currency, 0, 1, data.Rows.Count, data.Columns.Count - 1)); return(table); }
private List <ExcelRangeBase> AddNextRange( List <ExcelRangeBase> ranges, FormattedTable nextItem) { var prevRange = ranges.Last(); var prevRows = prevRange.End.Row - prevRange.Start.Row + 1; var nextRange = prevRange.Offset( prevRows + 1, 0, nextItem.RowCount, nextItem.ColumnCount); ranges.Add(nextRange); return(ranges); }
private FormattedTable GetHeadingTable() { var data = this.GetHeadingData(); // Create formatted table w/o autofiltering var table = new FormattedTable(data); table.AddTableFormatting(false); // Column renaming table.AddColumnRenaming("firstyear", "START YEAR"); table.AddColumnRenaming("numberyears", "ANALYSIS PERIOD"); table.AddColumnRenaming("inflationrate", "INFLATION RATE (%)"); table.AddColumnRenaming("discountrate", "DISCOUNT RATE (%)"); return(table); }
private FormattedTable GetHeadingTable() { var data = GetHeadingData(); // Create formatted table var table = new FormattedTable(data); table.AddTableFormatting(false); // Column renaming table.AddColumnRenaming("analysis", "OPTIMIZATION METHOD"); table.AddColumnRenaming("budget_constraint", "BUDGET"); table.AddColumnRenaming("benefit_variable", "BENEFIT"); table.AddColumnRenaming("benefit_limit", "BENEFIT LIMIT"); table.AddColumnRenaming("comments", "DESCRIPTION"); table.AddColumnRenaming("jurisdiction", "JURISDICTION CRITERIA"); return(table); }
private FormattedTable GetMainTable() { var data = this.GetMainData(); // Default sorting var view = data.DefaultView; view.Sort = data.Columns["attribute_"].ColumnName; // Create formatted table var table = new FormattedTable(view.ToTable()); table.AddTableFormatting(true); // Column renaming table.AddColumnRenaming("attribute_", "ATTRIBUTE"); table.AddColumnRenaming("equationname", "EQUATION NAME"); return(table); }
private FormattedTable GetMainTable() { var data = this.GetMainData(); // Default sorting var view = data.DefaultView; view.Sort = data.Columns["treatment"].ColumnName; // Create formatted table var table = new FormattedTable(view.ToTable()); table.AddTableFormatting(true); // Column renaming table.AddColumnRenaming("beforeany", "YEARS BEFORE ANY TREATMENT"); table.AddColumnRenaming("beforesame", "YEARS BEFORE SAME TREATMENT"); return(table); }
private FormattedTable GetMainTable() { var data = this.GetMainData(); // Default sorting var view = data.DefaultView; view.Sort = data.Columns["attribute_"].ColumnName; // Create formatted table var table = new FormattedTable(view.ToTable()); table.AddTableFormatting(true); // Column renaming table.AddColumnRenaming("attribute_", "ATTRIBUTE"); table.AddColumnRenaming("deficientname", "DEFICIENT NAME"); table.AddColumnRenaming("deficient", "DEFICIENT LEVEL"); table.AddColumnRenaming("percentdeficient", "ALLOWED DEFICIENT (%)"); return(table); }