/*********************************** * DAL METHODS ************************************/ // Read internal static PrintOptions ReadPrintOptionsFromReader(CustomOpenXmlReader reader, Worksheet worksheet) { PrintOptions printOptions = new PrintOptions(worksheet); foreach (CustomOpenXmlAttribute attribute in reader.Attributes) { switch (attribute.LocalName) { case "horizontalCentered": printOptions.HorizontalCentered = attribute.GetBoolValue(); break; case "verticalCentered": printOptions.VerticalCentered = attribute.GetBoolValue(); break; case "gridLines": printOptions.GridLines = attribute.GetBoolValue(); break; case "headings": printOptions.Headings = attribute.GetBoolValue(); break; default: throw new Exception(string.Format("PrintOptions attribute {0} not coded", attribute.LocalName)); } } return printOptions; }
/*********************************** * INTERNAL METHODS ************************************/ internal PrintOptions Clone(Worksheet worksheet) { PrintOptions newPrintOptions = new PrintOptions(worksheet, HorizontalCentered, VerticalCentered, GridLines, Headings); return newPrintOptions; }
// Write internal static void WritePrintOptionsToWriter(CustomOpenXmlWriter<OpenXmlPackaging.WorksheetPart> writer, PrintOptions printOptions) { if (printOptions.HasValue()) { writer.WriteOpenXmlElement(new OpenXmlSpreadsheet.PrintOptions()); if (printOptions.HorizontalCentered) writer.WriteAttribute("horizontalCentered", printOptions.HorizontalCentered); if (printOptions.VerticalCentered) writer.WriteAttribute("verticalCentered", printOptions.VerticalCentered); if (printOptions.GridLines) writer.WriteAttribute("gridLines", printOptions.GridLines); if (printOptions.Headings) writer.WriteAttribute("headings", printOptions.Headings); writer.WriteEndElement(); // PrintOptions } }