private void _ReadCommentsXml()
{
if (_cellComments != null)
{
return;
}
_cellComments = new CellComments();
if (isClosed || sheetIndex >= sheetCount)
{
return;
}
var reader = _GetCommentsReader();
if (reader == null)
{
return;
}
CellRef? k = null;
StringBuilder v = null;
while (reader.Read())
{
if (reader.Name == "comment")
{
var nt = reader.NodeType;
if (nt == XmlNodeType.Element)
{
k = new CellRef(reader.GetAttribute("ref"));
}
else if (nt == XmlNodeType.EndElement)
{
_cellComments.Add(k.Value, v.ToString());
k = null;
v = null;
}
continue;
}
if (k.HasValue && reader.IsStartElement("t"))
{
reader.Read();
if (v == null)
{
v = new StringBuilder();
}
v.Append(reader.Value);
continue;
}
}
}
public bool MoveToNextSheet()
{
if (isClosed || ++sheetIndex >= sheetCount)
{
return(false);
}
var sheetPath = _sheetPaths[_sheetRelsIds[sheetIndex]];
sheetName = _sheetNames[sheetIndex];
_sheetReader = _sheetReaders[sheetPath];
_cellComments = null;
cellRef = new CellRef(0, 0);
_cellValue = null;
return(true);
}
public ReadOnlyCellComments(CellComments cellComments)
{
_cellComments = cellComments;
}