Export xml to csv row

Question

I have the following xml file to give an idea of layout,

<weather>
<current_conditions>
<condition data="Mostly Cloudy" /> 
<temp_f data="48" /> 
<temp_c data="9" /> 
<humidity data="Humidity: 71%" /> 
<icon data="/ig/images/weather/mostly_cloudy.gif" /> 
<wind_condition data="Wind: W at 17 mph" /> 
</current_conditions>
<forecast_conditions>
<day_of_week data="Sun" /> 
<low data="34" /> 
<high data="48" /> 
<icon data="/ig/images/weather/mostly_sunny.gif" /> 
<condition data="Partly Sunny" /> 
</forecast_conditions>
<forecast_conditions>
<day_of_week data="Mon" /> 
<low data="32" /> 
<high data="45" /> 
<icon data="/ig/images/weather/sunny.gif" /> 
<condition data="Clear" /> 
</forecast_conditions>

I am learning c# and want to export to csv using a row for each day of the week, where info for a day is not available i need to show no data in the csv row. I appreciate the simplest solution as i am learning :)

string day = "Tue"; string path = "weather/forecast_conditions[day_of_week/@data='" + day + "']/condition"; string towrite = doc.XPathSelectElement(path).Attribute("data").Value; — dave2012
– dave2012, Commented Jan 24, 2012 at 21:27
I'd recommend editing your post and putting what you've tried into your question! The more code, the better! — Daniel Mann
– Daniel Mann, Commented Jan 24, 2012 at 21:36

David Esteves · Accepted Answer · 2012-01-24 21:42:20Z

1

I'm assuming you want to ignore the current conditions node as it doesn't make much sense to me to have a csv file where the columns don't all match the same data. For getting all the forecast info into a csv you can use:

XDocument doc = XDocument.Parse(...);    
StringBuilder sb = new StringBuilder(1000);
foreach (XElement node in doc.Descendants("forecast_conditions"))
{
    foreach(XElement innerNode in node.Elements())
    {
       sb.AppendFormat("{0},", innerNode.Attribute("data").Value);
    }
    //Remove trailing comma
    sb.Remove(sb.Length - 1, 1);
    sb.AppendLine();
}
File.WriteAllText(@"c:\temp.csv", sb.ToString());

answered Jan 24, 2012 at 21:42

David Esteves

1,6042 gold badges15 silver badges22 bronze badges

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

6 Comments

dave2012 Over a year ago

this is works thanks, how could i exclude an element for example icon data ?

dave2012 Over a year ago

Also I don't understand what the "1000" does after stringbuilder? thanks

David Esteves Over a year ago

Use an if statement on the innerNode object, one of the properties will contain the name of the node. The properties name is most likely Name though I'm not 100% sure.

David Esteves Over a year ago

The 1000 just sets the default capacity of the StringBuilder. It's not important and can be left out, but check dotnetperls.com/stringbuilder-capacity if you wish to know more

dave2012 Over a year ago

Sorry, i don't see how I can use an if statement to exclude a element?

|

Collectives™ on Stack Overflow

Export xml to csv row

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related