python菜鸟,想把xml存为excel文件
求大神指导!想把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>