Questions tagged [readxml]
113 questions
1
vote
1 answer
pandas.read_xml() unexpected behaviour
I am trying to understand why the code:
import pandas
xml = '''
1
2
3
4
5
Art Gertner
- 292
- 12
- 27
1
vote
2 answers
pandas read_xml : column gets overwritten by elements with same tag (but different attributes)
I'm trying to convert a xml file into a pandas dataframe with the read_xml function. The problem is that one of the nested elements is repeated several times (but with different attributes), and it seems that pandas creates only one column for this…
Fey010
- 15
- 3
1
vote
1 answer
SOAP Response to DataTable in C#
I have been searching and trying in many forms to pass an XML Response to a simple DataTable in the same way Excel does.
The XML is like:
Elder
- 45
- 1
- 3
- 7
1
vote
1 answer
pandas read_xml missing data
I have tried using Pandas read_xml and it reads most of the XML fine but it leaves some parts out because its in a slightly different format. I have included an extract below and it reads "Type", "Activation" fine but doesn't for the "Amt" value. It…
Dales91
- 21
- 1
- 6
1
vote
3 answers
C# The simplest way to obtain XML Data
I have been doing a lot of reading on LINQ to XML but unfortunately this topic (which is fairly new to me) simply will not click. Having said that, please feel free to correct any misspeaks regarding proper XML vocabulary. My goal is to take XML…
user725913
1
vote
2 answers
Read XML on SQL Server : Select custom attribute
I'm trying to read an XML, it works pretty well on the whole except for the attribute named :
1234567890
which I am trying to get the value "1234567890"
Here is the test…
Gaëtan Wauthy
- 31
- 5
1
vote
1 answer
ReadXml different behavior when windows user is not administrator
I know it's crazy but I'm facing an unexpected and really triggering issue.
When started, my application (vb.net desktop app in .net 4.7 fmk) reads an xml file containing some local settings for the app.
Now, the issue is that if I login into…
Efrael
- 557
- 1
- 4
- 11
1
vote
1 answer
Reading XML with numbers formatted with opposite decimal character (period/comma) in .NET
My VB.NET app is importing a XML file generated by a 3rd-party website into a SQL Server table. The website (and my computer) use the period character for decimals (e.g. 42.015) and everything works great. But a European user reported that numbers…
Scott
- 3,663
- 8
- 33
- 56
1
vote
1 answer
How to read XML files with initial tags in R
I have several XML files which are missing the initial tag. For example, this is the proper formatted file:-
Abdul Basit Khan
- 646
- 1
- 6
- 19
1
vote
4 answers
Reading the XML with namespaces at attribute level using c#
I have an XML file like following
Chandramouli
- 544
- 6
- 18
1
vote
1 answer
VBA - Read XML file
I need to read a XML file generated by an application to further do some automation. I am new to Excel VBA and have searched the net in vain!
Sample XML file -
sopana
- 365
- 1
- 5
- 15
1
vote
2 answers
How to read xml file in c# with specific attribute
I have an xml file with attribute
xmlns="http://www.reservwire.com/namespace/WebServices/Xml">
When I remove this attribute, then I can read each tag. If I don't remove attribute I receive error message "Object refrence not set to instance of…
Javed Abbas
- 5
- 1
1
vote
3 answers
Some Problem In Using DataSet.ReadXML
i want to use dataset.readxml for retrieve some data from xml file.But,my xml format is not well format,one part is for dataset and another part for other things.so,how i retrieve the dataset part.i am developing in c#.net 2008.xml file format is…
Chong
- 604
- 2
- 11
- 27
1
vote
2 answers
Read [for xml auto, elements] into DataTable in ADO.NET
I have MS SQL Server stored procedure that returns XML (it uses SELECT with for xml auto, elements)
I tried read it into DataTable:
DataTable retTable = new DataTable();
SqlCommand comm = new SqlCommand("exec MySP",…
ihorko
- 6,855
- 25
- 77
- 116
1
vote
1 answer
Reading XML in SQL which has one to many combination
See below example where I am trying to get result as 2 rows having same ClaimNo with different aliasType and aliasName.
Current result looks like this-
enter image description here
DECLARE @r TABLE (AliasesValue XML)
INSERT INTO @r
SELECT…
ravneet singh
- 21
- 1
- 3