private void SaveWriter()
{
try {
using (Stream stream = _worksheetPart.GetStream(FileMode.Create, FileAccess.Write)) {
using (var writer = XmlWriter.Create(stream)) {
writer.WriteStartElement("worksheet", Constants.MainNamespace);
writer.WriteAttributeString("xmlns", "r", null, Constants.RelationshipNamespace);
if (Cells.Columns.ColumnsList.Count > 0)
{
Cells.Columns.Write(writer);
}
Cells.Write(writer);
if (MergedCells.Cells.Count > 0)
{
MergedCells.Write(writer);
}
AutoFilter.Write(writer);
writer.WriteEndElement();
}
}
} catch (ObjectDisposedException) {
//Suppress any ObjectDisposedException thrown by multiple using statements
} catch {
throw;
}
}
/// <summary>
/// Initializes a new instance of the <see cref="Worksheet"/> class.
/// </summary>
/// <param name="styleSheet">The style sheet.</param>
/// <param name="worksheetPart">The worksheet part.</param>
internal Worksheet(Stylesheet styleSheet, PackagePart worksheetPart)
{
_styleSheet = styleSheet;
_worksheetPart = worksheetPart;
MergedCells = new MergedCells();
Cells = new Cells(_styleSheet, this);
AutoFilter = new AutoFilters();
}