Problems reading xml file

Question

I have a problem with reading XML which looks as follows:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<connections xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<connection id="1" odcFile="C:\Users\andr\Documents\My Data Sources\ELITE_MSSQLSERVER2012 PSO Reports.odc" keepAlive="1" name="ELITE_MSSQLSERVER2012 PSO Reports" type="5" refreshedVersion="5" background="1">
<dbPr connection="Provider=MSOLAP.5;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=PSO;Data Source=ELITE\MSSQLSERVER2012;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error" command="Reports" commandType="1"/>
<olapPr sendLocale="1" rowDrillCount="1000"/>
</connection>
</connections>

(it's actually a connection.xml file in *.xlsx package). I'm trying to read it with the help of XDocument. I need to change the "odcFile" property. The problem is that it reads the whole thing as a single element without children elements. Why so? XML looks normal. Or maybe there is another workaround to make this?

What is "it" in "it reads the whole thing"??? Where is the code that you have problem with? — Alexei Levenkov
– Alexei Levenkov, Commented Sep 9, 2013 at 23:24
"it" means XDocument. I tried var doc = XDocument.Load(connectionsFilePath); var connection = doc.Descendants("connection").First(); — KorsaR
– KorsaR, Commented Sep 9, 2013 at 23:49
So this doesn't work: d.Element(System.Xml.Linq.XNamespace.Get("http://schemas.openxmlformats.org/spreadsheetml/2006/main") + "connections").Element(System.Xml.Linq.XNamespace.Get("http://schemas.openxmlformats.org/spreadsheetml/2006/main") + "connection").Attribute("odcFile").SetValue("value"); (where d is the XDocument and value is the value you want to change odcFile to)? — UIlrvnd
– UIlrvnd, Commented Sep 10, 2013 at 0:31
possible duplicate of Use Linq to Xml with Xml namespaces or many other "select node with non-default namespace" question. — Alexei Levenkov
– Alexei Levenkov, Commented Sep 10, 2013 at 0:59

Brian Ogden · Accepted Answer · 2013-09-09 23:15:29Z

1

Try using System.Xml.Document instead, if you can access an actual xml file. Not sure what you mean by "it's actually a connection.xml file in *.xlsx package":

using System.Xml

XmlDocument dom = new XmlDocument();
XmlNone root;

dom.Load(fullpath);

root = dom.DocumentElement;

answered Sep 9, 2013 at 23:15

Brian Ogden

19.3k11 gold badges107 silver badges186 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

KorsaR Over a year ago

Thanks, this way everything works. But that's kind of strange, as the XDocument is not a third party thing, why it's so buggy then? And as for the *.xlsx package - I'm unzipping the Excel file to dynamicaly change its connection properties.

UIlrvnd Over a year ago

Linq to Xml has many advantages though, you can see an overview here. And i don't believe it's a bug, you're probably not using XNamespace correctly :).

Alexei Levenkov Over a year ago

@KorsaR - naming something "buggy" just because it follows public specification may be overkill. Consider reading about Xml namespaces...

Brian Ogden Over a year ago

If it works, go for it, XDocument works well with Linq but if you don't need or prefer to do Linq queries against the loaded Xml just use System.Xml.Document instead. It is possible that it is some kind of bug that System.Xml.Document correctly parses the xml into its parent and child nodes but XDocument does not. But again if you don't have a need to query the loaded Xml with Linq then just go with what works until requirements change.

MarcinJuraszek · Accepted Answer · 2013-09-10 18:13:59Z

1

You have to use proper XNamespace instance when querying this document. That's because your <connections> tag sets the default namespace to "http://schemas.openxmlformats.org/spreadsheetml/2006/main".

var xDoc = XDocument.Load("Input.txt");
var ns = XNamespace.Get("http://schemas.openxmlformats.org/spreadsheetml/2006/main");

var odcFile = xDoc.Root.Elements(ns + "connection")
                       .FirstOrDefault(x => (int)x.Attribute("id") == 1)
                       .Attribute("odcFile");

odcFile.Value = "newOdcValue";

xDoc.Save("Input.txt");

answered Sep 10, 2013 at 18:13

MarcinJuraszek

126k15 gold badges200 silver badges267 bronze badges

Collectives™ on Stack Overflow

Problems reading xml file

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related