TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
j k
NA
34
0
XML to excel/datagridview parsing
Aug 23 2011 3:41 PM
Hi All,
First of all I would like to thank you for the support. I am new in coding and need assistance in getting a specific xml content to an excel spreadsheet or to a datagridview.
the XML file is not a standard one (i think and below is a sample).
what i need from this xml file is the following data:
the name (Towers xxx] of the alert and the gps points (dont need the utm)
this is the xml
[code]
<?xml version="1.0" encoding="UTF-16"?>
<layer>
<name>
SF Zones
</name>
<alert_area_object>
<creation_time>
1303889594
</creation_time>
<name>
Tower 1
</name>
<description> Fence Alert </description>
<event_types num="1">
<event_type>
11111
</event_type>
</event_types>
<event_severity>
2
</event_severity>
<event_override_flag>
false
</event_override_flag>
<identities num="0"/>
<categories num="0"/>
<groups num="0"/>
<target_appear_in_area>
true
</target_appear_in_area>
<target_enter_area>
true
</target_enter_area>
<target_leave_area>
true
</target_leave_area>
<from_hour>
0
</from_hour>
<from_minute>
0
</from_minute>
<to_hour>
23
</to_hour>
<to_minute>
59
</to_minute>
<from_speed>
0
</from_speed>
<to_speed>
98.8889
</to_speed>
<weighting>
<weight>
<type>
2
</type>
<value> 99 </value>
</weight>
<weight>
<type> 204 </type>
<value>
99
</value>
</weight>
<weight>
<type>
205
</type>
<value>
99
</value>
</weight>
</weighting>
<visual_feedback>
true
</visual_feedback>
<sound_repeats>
-1
</sound_repeats>
<wave_file>
C:\4C\RunTime\OWP\Sounds\sirenwawa.wav
</wave_file>
<utm_zone>
40
</utm_zone>
<shape type="ClosedPolygon">
<num_of_alloc_points>
22
</num_of_alloc_points>
<num_of_points>
5
</num_of_points>
<geo_position lat="40.76876678920284" long="-73.98097831075269"/>
<geo_position lat="40.76869191861909" long="-73.98078254132794"/>
<geo_position lat="40.76839192572469" long="-73.97999998924834"/>
<geo_position lat="40.76749000414105" long="-73.97804528571041"/>
<geo_position lat="40.76643902004108" long="-73.97593868227233"/>
<utm_points x="132131" y="132131"/>
<utm_points x="132131" y="132131"/>
<utm_points x="132131" y="132131"/>
<utm_points x="132131" y="132131"/>
<utm_points x="132131" y="132131"/>
</shape>
</alert_area_object>
<alert_area_object>
<creation_time>
1303890003
</creation_time>
<name>
Towers 1 to 4
</name>
<description>
Fence Alert
</description>
<event_types num="1">
<event_type>
11111
</event_type>
</event_types>
<event_severity>
2
</event_severity>
<event_override_flag>
false
</event_override_flag>
<identities num="0"/>
<categories num="0"/>
<groups num="0"/>
<target_appear_in_area>
true
</target_appear_in_area>
<target_enter_area>
true
</target_enter_area>
<target_leave_area>
true
</target_leave_area>
<from_hour>
0
</from_hour>
<from_minute>
0
</from_minute>
<to_hour>
23
</to_hour>
<to_minute>
59
</to_minute>
<from_speed>
0
</from_speed>
<to_speed>
98.8889
</to_speed>
<weighting>
<weight>
<type>
2
</type>
<value>
99
</value>
</weight>
<weight>
<type>
204
</type>
<value>
99
</value>
</weight>
<weight>
<type>
205
</type>
<value>
99
</value>
</weight>
</weighting>
<visual_feedback>
true
</visual_feedback>
<sound_repeats>
-1
</sound_repeats>
<wave_file>
C:\4C\RunTime\OWP\Sounds\sirenwawa.wav
</wave_file>
<utm_zone>
40
</utm_zone>
<shape type="ClosedPolygon">
<num_of_alloc_points>
22
</num_of_alloc_points>
<num_of_points>
6
</num_of_points>
<geo_position lat="40.76876678920284" long="-73.98097831075269"/>
<geo_position lat="40.76869191861909" long="-73.98078254132794"/>
<geo_position lat="40.76839192572469" long="-73.97999998924834"/>
<geo_position lat="40.76749000414105" long="-73.97804528571041"/>
<geo_position lat="40.76643902004108" long="-73.97593868227233"/>
<utm_points x="132131" y="132131"/>
<utm_points x="132131" y="132131"/>
<utm_points x="132131" y="132131"/>
<utm_points x="132131" y="132131"/>
<utm_points x="132131" y="132131"/>
</shape>
</alert_area_object>
</layer>
[/code]
thanks again
Reply
Answers (
11
)
C#.net executable
What book/s did you read to learn C#?