private void WriteSheetFormatProperties(OpenExcelSheetFormatProperties sheetFormatProperties) { if (sheetFormatProperties == default) { sheetFormatProperties = new OpenExcelSheetFormatProperties(); } _workSheetWriter.WriteElement(new SheetFormatProperties { DefaultColumnWidth = sheetFormatProperties.DefaultColumnWidth, DefaultRowHeight = sheetFormatProperties.DefaultColumnHeight, CustomHeight = sheetFormatProperties.DefaultColumnHeight != 15 }); }
ISheetBuilder ISheetBuilder.InsertSheetWithFirstRowFrozenAs(string sheetName, OpenExcelSheetProperties sheetProperties, OpenExcelSheetFormatProperties sheetFormatProperties) { _api.WriteEndSheet(); (this as IExcelBuilder).InsertSheetWithFirstRowFrozenAs(sheetName, sheetProperties, sheetFormatProperties); return(this); }
ISheetBuilder IExcelBuilder.InsertSheetWithFirstRowFrozenAs(string sheetName, OpenExcelSheetProperties sheetProperties, OpenExcelSheetFormatProperties sheetFormatProperties) { var sheetViewProperties = new OpenExcelSheetViewProperties { PaneProperties = new OpenExcelSheetViewPaneProperties { XSplit = 0, YSplit = 1, TopLeftCell = "A2", State = PaneStateValues.FrozenSplit } }; (this as IExcelBuilder).InsertSheetAs(sheetName, sheetProperties, sheetViewProperties, sheetFormatProperties); return(this); }
ISheetBuilder IExcelBuilder.InsertSheetAs(string sheetName, OpenExcelSheetProperties sheetProperties, OpenExcelSheetViewProperties sheetViewProperties, OpenExcelSheetFormatProperties sheetFormatProperties) { _api.WriteStartSheet(sheetName, sheetProperties, sheetViewProperties, sheetFormatProperties); return(this); }
/// <summary> /// Starts writing sheet element /// </summary> /// <param name="sheetName"> Name of the Sheet. Empty or null sheet name will result in default sheet name.</param> /// <param name="sheetProperties"></param> /// <param name="sheetViewProperties"></param> public void WriteStartSheet(string sheetName = default, OpenExcelSheetProperties sheetProperties = default, OpenExcelSheetViewProperties sheetViewProperties = default, OpenExcelSheetFormatProperties sheetFormatProperties = default) { _colCharacterLengths.Clear(); _rowIdx = _rowIdxReset; var wsPart = _xl.WorkbookPart.AddNewPart <WorksheetPart>(); uint newSheetId = _newSheetId; _workBookWriter.WriteElement(new Sheet() { Name = (string.IsNullOrWhiteSpace(sheetName)) ? $"Sheet{newSheetId}" : sheetName, SheetId = newSheetId, Id = _xl.WorkbookPart.GetIdOfPart(wsPart) }); _workSheetWriter = OpenXmlWriter.Create(wsPart); _workSheetWriter.WriteStartElement(new Worksheet()); WriteSheetProperties(sheetProperties); WriteSheetViewProperties(sheetViewProperties); WriteSheetFormatProperties(sheetFormatProperties); _workSheetWriter.WriteStartElement(new SheetData()); }