private void CallAfterRenderMethod(string methodName, IXLRange range, IList <ExcelDynamicColumn> columns)
{
if (string.IsNullOrWhiteSpace(methodName))
{
return;
}
var args = new DataSourceDynamicPanelEventArgs
{
Range = range,
Columns = columns,
Data = _data
};
CallReportMethod(methodName, new[] { args });
}
public void TestExcelDynamicPanelAfterDataTemplatesRender(DataSourceDynamicPanelEventArgs args)
{
args.Range.Cells().ElementAt(5).Style.NumberFormat.Format = "#,0.0";
args.Range.Style.Border.OutsideBorder = XLBorderStyleValues.Thin;
args.Range.Style.Border.OutsideBorderColor = XLColor.Black;
}
public void TestExcelDynamicPanelAfterNumbersRender(DataSourceDynamicPanelEventArgs args)
{
args.Range.Style.Fill.BackgroundColor = XLColor.Gray;
args.Range.Style.Font.FontColor = XLColor.White;
}
public void TestExcelDynamicPanelAfterHeadersRender(DataSourceDynamicPanelEventArgs args)
{
args.Range.Style.Border.OutsideBorder = XLBorderStyleValues.Medium;
args.Range.Style.Border.OutsideBorderColor = XLColor.Red;
args.Range.Style.Font.Bold = true;
}
public void AfterDataTemplatesRender(DataSourceDynamicPanelEventArgs args)
{
args.Range.FirstCell().Style.Fill.BackgroundColor = XLColor.FromTheme(XLThemeColor.Background2);
args.Range.Range(1, 7, 1, 9).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Right;
}
