如下所示:我要将以下编码的站点编号、站点名称、经纬度等信息按一列一列的格式提取到excel当中,该怎样操作呢?
<dockStation ID="1">站点编号
<name>River Street , Clerkenwell</name>站点名称
<latitude>51.52916347</latitude>站点坐标:纬度
<longitude>-0.109970527</longitude>站点坐标:经度
<bikesAvailable>4</bikesAvailable>站点存车数
<emptySlots>15</emptySlots>站点空泊位数
<installed>true</installed>
<locked>false</locked>
<temporary>false</temporary>
</dockStation>
<dockStation ID="2">
<name>PhillimoreGardens, Kensington</name>
<latitude>51.49960695</latitude>
<longitude>-0.197574246</longitude>
<bikesAvailable>10</bikesAvailable>
<emptySlots>27</emptySlots>
<installed>true</installed>
<locked>false</locked>
<temporary>false</temporary>
</dockStation>