Exemple #1
0
        /// <summary>
        /// Get the XmlDocument from an URI
        /// </summary>
        /// <param name="uri">The Uri to the part</param>
        /// <returns>The XmlDocument</returns>
        internal XmlDocument GetXmlFromUri(Uri uri)
        {
            XmlDocument xml  = new XmlDocument();
            PackagePart part = _package.GetPart(uri);

            XmlHelper.LoadXmlSafe(xml, part.GetStream());
            return(xml);
        }
        private void CreateXml(ExcelPackage pck)
        {
            var  commentParts = Worksheet.Part.GetRelationshipsByType(ExcelPackage.schemaComment);
            bool isLoaded     = false;

            CommentXml = new XmlDocument();
            foreach (var commentPart in commentParts)
            {
                Uri  = PackUriHelper.ResolvePartUri(commentPart.SourceUri, commentPart.TargetUri);
                Part = pck.Package.GetPart(Uri);
                XmlHelper.LoadXmlSafe(CommentXml, Part.GetStream());
                RelId    = commentPart.Id;
                isLoaded = true;
            }
            //Create a new document
            if (!isLoaded)
            {
                CommentXml.LoadXml("<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\" ?><comments xmlns=\"http://schemas.openxmlformats.org/spreadsheetml/2006/main\"><authors /><commentList /></comments>");
                Uri = null;
            }
        }