internal void Export(XmlWriter writer)
{
// Worksheet
writer.WriteStartElement("Worksheet");
writer.WriteAttributeString("ss", "Name", null, Name);
ParentBook.ExportNamedRanges(writer, this);
// Table
writer.WriteStartElement("Table");
writer.WriteAttributeString("ss", "FullColumns", null, "1");
writer.WriteAttributeString("ss", "FullRows", null, "1");
if (!StyleID.IsNullOrEmpty() && StyleID != "Default")
{
writer.WriteAttributeString("ss", "StyleID", null, StyleID);
}
// Start Columns
foreach (Column col in _Columns)
{
col.Export(writer);
}
// End Columns
// Start Rows
foreach (Row row in _Rows)
{
row.Export(writer);
}
// End Rows
// End Table
writer.WriteEndElement();
// Write worksheet options
ExportOptions(writer);
// Write Autofilter options
if (AutoFilter)
{
string range = GetParentBook().GetAutoFilterRange(this);
writer.WriteStartElement("", "AutoFilter", "urn:schemas-microsoft-com:office:excel");
writer.WriteAttributeString("", "Range", null, range);
writer.WriteEndElement();
}
// End Worksheet
writer.WriteEndElement();
}
