Изменение экспорта в Excel

namespace ExcelExportServerExtension
{
	public class ExcelExportServerExtension : WebClientExtension (1)
	{
        private readonly IServiceProvider _serviceProvider;

		public ExcelExportServerExtension(IServiceProvider serviceProvider) (2)
			: base(serviceProvider)
		{
            this._serviceProvider = serviceProvider;
		}

		#region Свойства

		public override string ExtensionName => Assembly.GetAssembly(typeof(ExcelExportServerExtension)).GetName().Name; (3)

		public override Version ExtensionVersion => new Version(FileVersionInfo.GetVersionInfo(Assembly.GetExecutingAssembly().Location).FileVersion); (4)

		#endregion Свойства

		#region Обработчики событий

        public override void InitializeContainer(ContainerBuilder containerBuilder) (5)
        {
			containerBuilder.RegisterType<ExcelExportExampleService>()
                .As<IExcelExportService>()
                .SingleInstance(); (6)
        }

		#endregion Обработчики событий
    }
}

namespace ExcelExportServerExtension.ExcelExport (1)
{
    public class ExcelExportExampleService : ExcelExportService
    {
        private readonly Color oddRowColor = Color.LightBlue; (2)

        protected override void ApplyWorkbookSettings(XLWorkbook workbook) (3)
        {
            foreach (var worksheet in workbook.Worksheets)
            {
                for (var i = 1; i < worksheet.RangeUsed().RowCount(); i += 2) (4)
                {
                    var row = worksheet.RangeUsed().Row(i);
                    row.Style.Fill.BackgroundColor = XLColor.FromColor(oddRowColor);
                }
            }
        }

        protected override string GetGridRowParamValueAsString(object paramValue) (5)
        {
            if (paramValue is DateTime dateTime) (6)
            {
                return dateTime.ToLongDateString();
            }

            return base.GetGridRowParamValueAsString(paramValue);
        }

        protected override IEnumerable<GridColumn> GetGridColumns(GridViewModel viewModel) =>
            viewModel.Columns.Select(gridColumn => CreateGridColumnModel(gridColumn, viewModel))
                .OrderBy(column => column.UserColumn?.Order ?? 0)
                .Select(column => column.GridColumn); (7)

        private static GridColumnModel CreateGridColumnModel(GridColumn gridColumn, GridViewModel viewModel) => new GridColumnModel
        {
            GridColumn = gridColumn,
            UserColumn = viewModel.GridUserSettings
                .GetColumnsForCurrentPresentation()
                .FirstOrDefault(x => x.Name == gridColumn.Name)
        };
    }
}