static void InitStyles(SpreadsheetDocument doc) { superscript = new RunProperties( new VerticalTextAlignment() { Val = VerticalAlignmentRunValues.Superscript } , new FontSize() { Val = 11.0 } ); var stylesheet = doc.GetStylesheet(); styleRed = stylesheet.MakeCellStyle().WithFill("FF9090").Build(); var titleFont = new Font() { FontSize = new FontSize() { Val = 18U }, Bold = new Bold() { Val = true } }; styleGreen = stylesheet.MakeCellStyle().WithFill("90FF90").WithFont(titleFont).Build(); styleBlue = stylesheet.MakeCellStyle().WithFill("9090FF").Build(); }
/// <summary> /// Удаленин элементов TimelineStyles /// </summary> /// <param name="doc"></param> public static void RemoveOffice2013TimelineStyles(SpreadsheetDocument doc) { var stylesheet = doc.GetStylesheet(); var timelineStyles = stylesheet.Descendants <excel2013.TimelineStyles>(); ElementsRemove.RemoveElements(timelineStyles, deleteSectionIfEmpty: true); }
public ExcelHelper(string fileName, bool editable = true, int header = 1) { if (string.IsNullOrEmpty(fileName)) { throw new Exception("Check if current filename is empty!"); } if (!File.Exists(fileName)) { throw new Exception("Please make sure current file exists!"); } document = SpreadsheetDocument.Open(fileName, editable); worksheet = document.GetWorksheet(0); sheetData = worksheet.GetSheetData(); styleSheet = document.GetStylesheet(); this.Header = header; this.cellFormatOption = CellFormatOption.OverWrite; }