void ReadSharedStrings()
{
_sharedStrings = new List <string>();
_sharedStringIndex = new Dictionary <string, int>();
var nodes = SharedStringsXml.XPathSelectElements("//d:si", _nsManager).ToList();
for (int stringId = 0; stringId < nodes.Count; stringId++)
{
var stringNode = nodes[stringId];
var text = stringNode.Value;
_sharedStrings.Add(text);
_sharedStringIndex.Add(text, stringId);
}
}
void ReadSharedStrings()
{
_sharedStrings = new List <string>();
_sharedStringIndex = new Dictionary <string, int>();
XmlNodeList nodes = SharedStringsXml.SelectNodes("//d:si", _nsManager);
for (int stringId = 0; stringId < nodes.Count; stringId++)
{
XmlNode stringNode = nodes[stringId];
String text = stringNode.InnerText;
_sharedStrings.Add(text);
_sharedStringIndex.Add(text, stringId);
}
}
void WriteSharedStrings()
{
if (SharedStrings.Count == 0)
{
return;
}
CreateSharedStringsDoc();
foreach (String str in SharedStrings)
{
XmlElement stringNode = SharedStringsXml.CreateElement("si", ExcelPackage.schemaMain);
XmlElement textNode = SharedStringsXml.CreateElement("t", ExcelPackage.schemaMain);
textNode.InnerText = str;
stringNode.AppendChild(textNode);
SharedStringsXml.DocumentElement.AppendChild(stringNode);
}
}
