private void InitStyles() { StylesNode = XmlDocument.CreateElement(LocalNames.Styles, ROOT_NAMESPACE); WorkbookNode.AppendChild(StylesNode); AddStyle(StyleIds.ShortDate, "NumberFormat", "Format", "Short Date"); AddStyle(StyleIds.Header, "Font", "Bold", "1"); AddStyle(StyleIds.Paragraph, "Alignment", "WrapText", "1"); }
/// <summary> /// Add a Worksheet to the end of the list of Worksheets, containing an empty Table. /// </summary> /// <param name="title">Worksheet title.</param> /// <returns>The index of the worksheet/table.</returns> public int AddWorksheet(string title) { XmlNode worksheetNode = XmlDocument.CreateElement("ss", LocalNames.Worksheet, PREFIX_NAMESPACEURI["ss"]); WorkbookNode.AppendChild(worksheetNode); XmlAttribute titleAttribute = XmlDocument.CreateAttribute("ss", Attributes.Name, PREFIX_NAMESPACEURI["ss"]); titleAttribute.Value = title; worksheetNode.Attributes.Append(titleAttribute); XmlNode tableNode = XmlDocument.CreateElement(LocalNames.Table, ROOT_NAMESPACE); worksheetNode.AppendChild(tableNode); tableNodes.Add(tableNode); XmlNode optionsNode = XmlDocument.CreateElement("x", LocalNames.WorksheetOptions, PREFIX_NAMESPACEURI["x"]); worksheetNode.AppendChild(optionsNode); return(tableNodes.Count - 1); }