Click here to Skip to main content
15,945,603 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi All,

I have the following URL is being used as the DataSource of to a Google Charts.

HTML
<a href="https://spreadsheets.google.com/tq?key=pCQbetd-CptHnwJEfo8tALA">https://spreadsheets.google.com/tq?key=pCQbetd-CptHnwJEfo8tALA</a>[<a href="https://spreadsheets.google.com/tq?key=pCQbetd-CptHnwJEfo8tALA" target="_blank" title="New Window">^</a>


The Data within the location of that URL is as the below

C#
// Data table response
google.visualization.Query.setResponse({"version":"0.6","status":"ok","sig":"598319012","table":{"cols":[{"id":"A","label":"Element","type":"string","pattern":""},{"id":"B","label":"Percent","type":"number","pattern":"#0.###############"}],"rows":[{"c":[{"v":"iron"},{"v":32.1,"f":"32.1"}]},{"c":[{"v":"oxygen"},{"v":30.1,"f":"30.1"}]},{"c":[{"v":"silicon"},{"v":15.1,"f":"15.1"}]},{"c":[{"v":"magnesium"},{"v":13.9,"f":"13.9"}]},{"c":[{"v":"sulfur"},{"v":2.9,"f":"2.9"}]},{"c":[{"v":"nickel"},{"v":1.8,"f":"1.8"}]},{"c":[{"v":"calcium"},{"v":1.5,"f":"1.5"}]},{"c":[{"v":"aluminium"},{"v":1.4,"f":"1.4"}]}]}});


Now what I want is this data to be in an XML file that locally resides and retrieve from there to draw the Google Chart.

So what can I do to this to solve my problem? Please could you someone help me to solve this matter?

Thanks and regards,
Chiranthaka
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900