// Write
internal static void WriteWorksheetFormatToWriter(CustomOpenXmlWriter<OpenXmlPackaging.WorksheetPart> writer, WorksheetFormat worksheetFormat)
{
if (worksheetFormat.HasValue())
{
writer.WriteOpenXmlElement(new OpenXmlSpreadsheet.SheetFormatProperties());
if (worksheetFormat.DefaultRowHeight > 0)
writer.WriteAttribute("defaultRowHeight", worksheetFormat.DefaultRowHeight);
writer.WriteEndElement(); // SheetFormatProperties
}
}
/***********************************
* DAL METHODS
************************************/
// Read
internal static WorksheetFormat ReadWorksheetFormatFromReader(CustomOpenXmlReader reader, Worksheet worksheet)
{
WorksheetFormat worksheetFormat = new WorksheetFormat(worksheet);
foreach (CustomOpenXmlAttribute attribute in reader.Attributes)
{
switch (attribute.LocalName)
{
case "defaultRowHeight":
worksheetFormat.DefaultRowHeight = attribute.GetDoubleValue();
break;
}
}
return worksheetFormat;
}
/***********************************
* INTERNAL METHODS
************************************/
internal WorksheetFormat Clone(Worksheet worksheet)
{
WorksheetFormat newFormat = new WorksheetFormat(worksheet, DefaultRowHeight);
return newFormat;
}
