public void BeforeHeadersRender(DataSourceDynamicPanelBeforeRenderEventArgs args)
{
foreach (var column in args.Columns)
{
}
//args.Columns[6].AggregateFunction = AggregateFunction.Max;
//args.Columns[7].AggregateFunction = AggregateFunction.Min;
//args.Columns[8].DisplayFormat = "$#,0.00";
}
public void TestExcelDynamicPanelBeforeHeadersRender(DataSourceDynamicPanelBeforeRenderEventArgs args)
{
args.Columns[0].Width = 30;
args.Columns[0].AggregateFunction = AggregateFunction.Avg;
args.Columns[1].AdjustToContent = true;
args.Columns.Add(new ExcelDynamicColumn("DynamicAdded", typeof(decimal?), "Dynamic added")
{
Width = 20
});
}
private bool CallBeforeRenderMethod(string methodName, IXLRange range, IList <ExcelDynamicColumn> columns)
{
if (string.IsNullOrWhiteSpace(methodName))
{
return(false);
}
var args = new DataSourceDynamicPanelBeforeRenderEventArgs
{
Range = range,
Columns = columns,
Data = _data
};
CallReportMethod(methodName, new[] { args });
return(args.IsCanceled);
}
public void TestExcelDynamicPanelBeforeNumbersRender(DataSourceDynamicPanelBeforeRenderEventArgs args)
{
args.Range.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
}
