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);
}
