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