private void SetSheetSettings(IOneTableExcelReportConfiguration configuration) { var memberOptions = configuration.MemberConfigurations.GetActiveOrderlyOptions(); var columnNumber = 1; foreach (var oneTableExcelMemberOptions in memberOptions) { Column(columnNumber, builder => { if (oneTableExcelMemberOptions.Width > 0) { builder.Width(oneTableExcelMemberOptions.Width); } if (oneTableExcelMemberOptions.IsAutoFitColumn) { builder.AutoFitColumn(); } if (string.IsNullOrWhiteSpace(oneTableExcelMemberOptions.Format)) { builder.Format(oneTableExcelMemberOptions.Format); } }); columnNumber++; } }
public virtual void DataContent <T>(IEnumerable <T> data, IOneTableExcelReportConfiguration configuration) where T : class { SetSheetSettings(configuration); var baseConfiguration = ConvertToExcelReportConfiguration <T>(configuration); DataContentInternal(data, baseConfiguration); }
private static ExcelReportConfiguration.EntityConfig.ExcelReportConfiguration ConvertToExcelReportConfiguration <T>( IOneTableExcelReportConfiguration configuration) where T : class { var members = new MemberConfigurationDictionary <ExcelMemberOptions>(); foreach (var options in configuration.MemberConfigurations) { members.Add(options.Key, options.Value); } var baseConfiguration = new ExcelReportConfiguration.EntityConfig.ExcelReportConfiguration(configuration.Options, members); return(baseConfiguration); }