public void RunMultiyearTest() { PrepareUnitTest(); string fn = WorkingDirectory.Combine("trend.xlsx"); Config.LimitToScenarios.Clear(); Config.InitializeSlices(Logger); MultiyearMultiVariableTrend trend = new MultiyearMultiVariableTrend(); Random rnd = new Random(); if (Config.Slices == null) { throw new FlaException("No slices"); } trend[Constants.PresentSlice].AddValue("MyValue", "mycategory", 50, DisplayUnit.Stk); trend[Constants.PresentSlice].AddValue("MyValue", "mycategory2", 50, DisplayUnit.Stk); foreach (var slice in Config.Slices) { Info("Slice " + slice); trend[slice].AddValue("MyValue", "mycategory", rnd.Next(100), DisplayUnit.Stk); trend[slice].AddValue("MyValue", "mycategory2", rnd.Next(100), DisplayUnit.Stk); } XlsxDumper.DumpMultiyearMultiVariableTrendToExcel(fn, trend); Info("Wrote to " + fn); Process.Start(fn); }
public void RunMultiyearTestSingleColumn() { PrepareUnitTest(); string fn = WorkingDirectory.Combine("trend3.xlsx"); Config.LimitToScenarios.Clear(); Config.InitializeSlices(Logger); MultiyearTrend trend = new MultiyearTrend(); Random rnd = new Random(); if (Config.Slices == null) { throw new FlaException("No slices"); } trend[Constants.PresentSlice].AddValue("MyValue", 50, DisplayUnit.Stk); foreach (var slice in Config.Slices) { if (slice.DstScenario != Scenario.FromEnum(ScenarioEnum.Nep)) { continue; } trend[slice].AddValue("MyValue", rnd.Next(100), DisplayUnit.Stk); } XlsxDumper.DumpMultiyearTrendToExcel(fn, trend); Info("Wrote to " + fn); Process.Start(fn); }
public void RunTest() { PrepareUnitTest(); RowCollection rc = new RowCollection("mysheet", "MySheet"); var rb = RowBuilder.Start("t1", "mytxt").Add("blub", 1).Add("blub2", 1); rc.Add(rb); var rb2 = RowBuilder.Start("t1", "mytxt").Add("blub", 1).Add("blub5", 1); rc.Add(rb2); XlsxDumper.WriteToXlsx(WorkingDirectory.Combine("t.xlsx"), rc); }