private void ExportOptions(XmlWriter writer)
{
writer.WriteStartElement("", "WorksheetOptions", "urn:schemas-microsoft-com:office:excel");
PrintOptions.Export(writer);
writer.WriteElementString("Selected", "");
if (TabColor != -1)
{
writer.WriteElementString("TabColor", TabColor.ToString(CultureInfo.InvariantCulture));
}
if (FreezeLeftColumns > 0 || FreezeTopRows > 0)
{
writer.WriteElementString("FreezePanes", "");
writer.WriteElementString("FrozenNoSplit", "");
if (FreezeTopRows > 0)
{
writer.WriteElementString("SplitHorizontal", FreezeTopRows.ToString(CultureInfo.InvariantCulture));
writer.WriteElementString("TopRowBottomPane", FreezeTopRows.ToString(CultureInfo.InvariantCulture));
}
if (FreezeLeftColumns > 0)
{
writer.WriteElementString("SplitVertical", FreezeLeftColumns.ToString(CultureInfo.InvariantCulture));
writer.WriteElementString("LeftColumnRightPane", FreezeLeftColumns.ToString(CultureInfo.InvariantCulture));
}
WritePanes(writer);
}
writer.WriteEndElement();
}
