// 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; }