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); } }