nsrdata
09-09-2007, 12:18 AM
Hi All,
Hope you are doing well today!
I'm new to XML, I've XML file, Which trying to download into Excel File, but i'm getting error called, "Invliad XML Declaration". Following is the XML code.
<?xml version="1.0"?>
<shares>
<Ric>ATLN.S</Ric>
<CurrentPrice>65.90</CurrentPrice>
<Change>-0.60</Change>
<change>-0.90</change>
<Time>17:31 CET</Time>
<Date>07/09/2007</Date>
<Bid>65.90</Bid>
<Ask>66.05</Ask>
<High>67.00</High>
<Low>65.50</Low>
<Open>66.45</Open>
<PreviousClose>66.50</PreviousClose>
<Volume>1,995,096</Volume>
<YearHigh>70.40</YearHigh>
<YearLow>32.42</YearLow>
<MarketCap>8079.156953</MarketCap>
</sharepricedetails>
</shares>
Here The way I'm importing into Excel file
Open any Excel File. goto Data Manu in Excel file ---Say Import data from XML file.
Please help me how to solve the problem.
Thanks in Advance
Thanks & Regards
Narayan
Hope you are doing well today!
I'm new to XML, I've XML file, Which trying to download into Excel File, but i'm getting error called, "Invliad XML Declaration". Following is the XML code.
<?xml version="1.0"?>
<shares>
<Ric>ATLN.S</Ric>
<CurrentPrice>65.90</CurrentPrice>
<Change>-0.60</Change>
<change>-0.90</change>
<Time>17:31 CET</Time>
<Date>07/09/2007</Date>
<Bid>65.90</Bid>
<Ask>66.05</Ask>
<High>67.00</High>
<Low>65.50</Low>
<Open>66.45</Open>
<PreviousClose>66.50</PreviousClose>
<Volume>1,995,096</Volume>
<YearHigh>70.40</YearHigh>
<YearLow>32.42</YearLow>
<MarketCap>8079.156953</MarketCap>
</sharepricedetails>
</shares>
Here The way I'm importing into Excel file
Open any Excel File. goto Data Manu in Excel file ---Say Import data from XML file.
Please help me how to solve the problem.
Thanks in Advance
Thanks & Regards
Narayan