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());
}
