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)
{
}
