private void WriteRow(TabularRow row)
{
// write meta cols
writer.WriteField(row.Key);
writer.WriteField(row.Name);
writer.WriteField(row.Unit);
// write data cols
row.Values.ToList().ForEach(v => writer.WriteField(v));
writer.NextRecord();
}
private void WriteRow(uint rowNumber, TabularRow row)
{
// write meta cols
worksheet.Cells[rowNumber, 1] = row.Key;
worksheet.Cells[rowNumber, 2] = row.Name;
worksheet.Cells[rowNumber, 3] = row.Unit;
uint colNumber = 4;
// write data cols
row.Values.ToList().ForEach(v =>
{
worksheet.Cells[rowNumber, colNumber] = v;
colNumber++;
});
}
public Tabular <T> Add(T apiResource)
{
// append header column using period
header.Add(apiResource.GetPeriod().ToString());
var selector = new FormattedValueSelector(apiResource);
// setup keys and values if empty
if (keys.Count == 0)
{
apiResource.GetPropertyNames().ToList().ForEach(p =>
{
keys.Add(p);
rowDict.Add(p, TabularRow.Create(apiResource.GetDescription(p)));
});
}
// add each formatted values to the row
keys.ForEach(p => rowDict[p].Add(selector.Select(p)));
return(this);
}
