public WorksheetTemplateDemo(WorksheetConfig sheetSetting) { this.setting = sheetSetting; this.name = sheetSetting.Name; if (this.setting.DataSource != null) { this.totalColumns = this.setting.DataSource.Columns.Count; } }
protected override void SetStyle() { WorksheetConfig setting = new WorksheetConfig(); //set page setting.Content.BorderStyle = XLBorderStyleValues.Thin; setting.ShowGridLine = false; setting.Content.WrapText = false; setting.TableHeader.Style.Bold = false; setting.PageSetup.PageOrientation = XLPageOrientation.Landscape; setting.PageSetup.PaperSize = XLPaperSize.A4Paper; //set style base styleBase = new ExcelStyle(); styleBase.Horizontal = XLAlignmentHorizontalValues.Center; styleBase.Bold = true; //styleheader styleheader = styleBase.Clone(); styleheader.Bold = false; //style title styletitle = styleBase.Clone(); styletitle.Horizontal = XLAlignmentHorizontalValues.Center; styletitle.FontSize = 18; styletitle.FontColor = Color.Blue; //style table header styleTableheader = styleBase.Clone(); styleTableheader.Horizontal = XLAlignmentHorizontalValues.Left; styleTableheader.Bold = true; setting.TableHeader.Style = styleTableheader; //style sub title stylesubtitle = styleBase.Clone(); stylesubtitle.Horizontal = XLAlignmentHorizontalValues.Center; stylesubtitle.Bold = false; stylesubtitle.FontSize = 10; stylesubtitle.Italic = true; setting.Title.SubTitle.Style = stylesubtitle; setting.Title.Title.Style = styletitle; this.setting = setting; }
public WorksheetConfig Clone(WorksheetConfig setting) { var serialized = JsonConvert.SerializeObject(setting); return(JsonConvert.DeserializeObject <WorksheetConfig>(serialized)); }
public WorksheetLayoutLevel1(WorksheetConfig sheetConfig) : base(sheetConfig) { this.SetStyle(); }
public WorksheetDemo(WorksheetConfig sheetSetting) : base(sheetSetting) { }