python菜鸟,想把xml存为excel文件

eagleeyexh 2018-02-09 04:14:38
求大神指导!想把xml存为excel文件,下面的xml文件有多个同名param标签,实在想不出用哪个模块处理。
还求指点,菜鸟入门。

<?xml version="1.0" encoding="GBK"?>
<Output type="m">
<param name="pageIndex" type="i">
<![CDATA[1]]>
</param>
<param name="totalSize" type="i">
<![CDATA[4]]>
</param>
<param name="totalRecords" type="i">
<![CDATA[68]]>
</param>
<param name="resultList" type="c">
<param type="m">
<param name="happenDate" type="t">
<![CDATA[2018-01-03 13:58:08]]>
</param>
<param name="responseOrg" type="s">
<![CDATA[传输网支撑处]]>
</param>
<param name="responsibilityOrgName" type="s">
<![CDATA[传输网支撑处]]>
</param>
<param name="faultLevelId" type="f">
<![CDATA[140]]>
</param>
<param name="telReportDate" type="t">
<![CDATA[2018-01-03 13:59:00]]>
</param>
<param name="createOrgName" type="s">
<![CDATA[网络监控处]]>
</param>
<param name="faultDetailDocName"/>
<param name="belongDistrictName"/>
<param name="dealDocId"/>
<param name="faultLinkman"/>
<param name="equipmentFactory"/>
<param name="faultLevelName" type="s">
<![CDATA[其他故障C2级别-传输优化故障单]]>
</param>
<param name="faultTitle" type="s">
<![CDATA[华为-华为187(U2000)-9477-嘉定锦湖轮胎/80,81 - ECXL/:复用段倒换指示扩展]]>
</param>
<param name="bussComebackDate" type="t">
<![CDATA[2018-01-04 07:45:36]]>
</param>
<param name="dealDetail" type="s">
<![CDATA[网管手动倒换恢复后告警消失]]>
</param>
<param name="responsibilityPartyType" type="s">
<![CDATA[ORG]]>
</param>
<param name="state" type="f">
<![CDATA[1]]>
</param>
<param name="dealMethod" type="f">
<![CDATA[1]]>
</param>
<param name="equipmentIp"/>
<param name="handlePartyId" type="f">
<![CDATA[11190]]>
</param>
<param name="handlePartyType" type="s">
<![CDATA[ORG]]>
</param>
<param name="createStaffName" type="s">
<![CDATA[高娜]]>
</param>
<param name="responsibilityOrgId" type="f">
<![CDATA[11190]]>
</param>
<param name="reasonComment" type="s">
<![CDATA[R_LOS告警引起,R_LOS告警恢复后网管手动倒换恢复后告警消失]]>
</param>
<param name="specialtyKindName" type="s">
<![CDATA[传输]]>
</param>
<param name="equipmentName"/>
<param name="accNbr"/>
<param name="sendDate" type="t">
<![CDATA[2018-01-03 13:59:52]]>
</param>
<param name="isInterrupt" type="f">
<![CDATA[1]]>
</param>
<param name="handleOrgPathCode" type="s">
<![CDATA[0.441.11182.11190]]>
</param>
<param name="alarmIsRecovery" type="s">
<![CDATA[是]]>
</param>
<param name="enterDate"/>
<param name="faultDetail" type="s">
<![CDATA[告警网管:华为187(U2000),告警网元]]>
</param>
<param name="recoverDate" type="t">
<![CDATA[2018-01-04 07:45:36]]>
</param>
<param name="createStaffId" type="f">
<![CDATA[522866]]>
</param>
<param name="orderState" type="f">
<![CDATA[6]]>
</param>
<param name="dealPerson" type="s">
<![CDATA[传输网支撑处]]>
</param>
<param name="faultLevelCode"/>
<param name="orderStateName" type="s">
<![CDATA[已归档]]>
</param>
<param name="cusName"/>
<param name="handlePartyName" type="s">
<![CDATA[传输网支撑处]]>
</param>
<param name="equipmentAdress"/>
<param name="handleOrgName" type="s">
<![CDATA[传输网支撑处]]>
</param>
<param name="createOrgId" type="f">
<![CDATA[11192]]>
</param>
<param name="responsibilityPartyName" type="s">
<![CDATA[传输网支撑处]]>
</param>
<param name="dealDocName"/>
<param name="passTime"/>
<param name="orderCode" type="s">
<![CDATA[AGZ-20180103-0649]]>
</param>
<param name="netLevelName"/>
<param name="handleOrgId" type="f">
<![CDATA[11190]]>
</param>
<param name="specialtyKindId" type="f">
<![CDATA[10]]>
</param>
</param>
<param type="m">
<param name="happenDate" type="t">
<![CDATA[2018-01-03 13:55:38]]>
</param>
<param name="responseOrg" type="s">
<![CDATA[传输网支撑处]]>
</param>
<param name="responsibilityOrgName" type="s">
<![CDATA[传输网支撑处]]>
</param>
<param name="faultLevelId" type="f">
<![CDATA[140]]>
</param>
<param name="telReportDate" type="t">
<![CDATA[2018-01-03 13:58:00]]>
</param>
<param name="createOrgName" type="s">
<![CDATA[网络监控处]]>
</param>
<param name="faultDetailDocName"/>
<param name="belongDistrictName"/>
<param name="equipmentFactory"/>
<param name="faultLevelName" type="s">
<![CDATA[其他故障C2级别-传输优化故障单]]>
</param>
<param name="faultTitle" type="s">
<![CDATA[华为-华为187(U2000)-9962-嘉定大客户子架 / 9,10- SXCSA/复用段倒换指示扩展]]>
</param>
<param name="bussComebackDate" type="t">
<![CDATA[2018-01-04 07:46:29]]>
</param>
<param name="preHandle" type="s">
<![CDATA[无]]>
</param>
<param name="orderId" type="f">
<![CDATA[25480899]]>
</param>
<param name="responsibilityPartyId" type="f">
<![CDATA[11190]]>
</param>
<param name="netLevelId"/>
<param name="faultDetailDocId"/>
<param name="dealDetail" type="s">
<![CDATA[网管手动倒换恢复后告警消失]]>
</param>
<param name="responsibilityPartyType" type="s">
<![CDATA[ORG]]>
</param>
<param name="state" type="f">
<![CDATA[1]]>
</param>
<param name="dealMethod" type="f">
<![CDATA[1]]>
</param>
<param name="equipmentIp"/>
<param name="handlePartyId" type="f">
<![CDATA[11190]]>
</param>
<param name="handlePartyType" type="s">
<![CDATA[ORG]]>
</param>
<param name="createStaffName" type="s">
<![CDATA[高娜]]>
</param>
<param name="responsibilityOrgId" type="f">
<![CDATA[11190]]>
</param>
<param name="reasonComment" type="s">
<![CDATA[R_LOS告警引起,R_LOS告警恢复后网管手动倒换恢复后告警消失]]>
</param>
<param name="specialtyKindName" type="s">
<![CDATA[传输]]>
</param>
<param name="equipmentName"/>
<param name="accNbr"/>
<param name="sendDate" type="t">
<![CDATA[2018-01-03 13:58:41]]>
</param>
<param name="isInterrupt" type="f">
<![CDATA[1]]>
</param>
<param name="handleOrgPathCode" type="s">
<![CDATA[0.441.11182.11190]]>
</param>
<param name="alarmIsRecovery" type="s">
<![CDATA[是]]>
</param>
<param name="enterDate"/>
<param name="faultDetail" type="s">
<![CDATA[传输衍生 [告警网管:华为187(U2000), SXCSA]]>
</param>
<param name="recoverDate" type="t">
<![CDATA[2018-01-04 07:46:29]]>
</param>
<param name="createStaffId" type="f">
<![CDATA[522866]]>
</param>
<param name="orderState" type="f">
<![CDATA[6]]>
</param>
<param name="dealPerson" type="s">
<![CDATA[传输网支撑处]]>
</param>
<param name="faultLevelCode"/>
<param name="orderStateName" type="s">
<![CDATA[已归档]]>
</param>
<param name="cusName"/>
<param name="handlePartyName" type="s">
<![CDATA[传输网支撑处]]>
</param>
<param name="equipmentAdress"/>
<param name="handleOrgName" type="s">
<![CDATA[传输网支撑处]]>
</param>
<param name="createOrgId" type="f">
<![CDATA[11192]]>
</param>
<param name="responsibilityPartyName" type="s">
<![CDATA[传输网支撑处]]>
</param>
<param name="dealDocName"/>
<param name="passTime"/>
<param name="orderCode" type="s">
<![CDATA[AGZ-20180103-0648]]>
</param>
<param name="netLevelName"/>
<param name="handleOrgId" type="f">
<![CDATA[11190]]>
</param>
<param name="specialtyKindId" type="f">
<![CDATA[10]]>
</param>
</param>
</param>
</Output>
...全文
1444 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
zjcxc 2018-02-11
  • 打赏
  • 举报
回复
你的数据具体要在 Excel 中怎么对应?
oyljerry 2018-02-09
  • 打赏
  • 举报
回复
用param的name做为列,然后一组数据作为一行。

37,719

社区成员

发帖
与我相关
我的任务
社区描述
JavaScript,VBScript,AngleScript,ActionScript,Shell,Perl,Ruby,Lua,Tcl,Scala,MaxScript 等脚本语言交流。
社区管理员
  • 脚本语言(Perl/Python)社区
  • IT.BOB
加入社区
  • 近7日
  • 近30日
  • 至今

试试用AI创作助手写篇文章吧