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