public void AddSheet(Sheet sheet)
{
if(sheet == null)
{
throw new ArgumentNullException("You cannot add null sheet to the workbook");
}
this._sheets.Add(sheet);
}
public void RemoveSheet(Sheet sheet)
{
this._sheets.Remove(sheet);
}
private void PopulateSheet(Sheet sheet, string sheetXml)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(sheetXml);
XmlNode sheetData = this.FindNodeByNameRecursively("sheetData", xmlDoc);
foreach(XmlNode row in sheetData)
{
foreach(XmlNode cell in row)
{
XmlNode type = cell.Attributes.GetNamedItem("t");
string typeName = type != null ? type.InnerText : String.Empty;
string cellCoords = cell.Attributes.GetNamedItem("r").InnerText;
XmlNode cellValue = this.FindNodeByNameRecursively("v", cell);
string value = cellValue != null ? cellValue.InnerText : null;
if (!string.Equals(typeName, "s"))
{
sheet[cellCoords] = value;
}
else
{
int index = int.Parse(value);
sheet[cellCoords] = this.Workbook.GetSharedString(index);
}
}
}
}