我想写python文件输出到xls或xlxs-fi

Question

我想写用户名和输出（taksh）在xls文件。我想为1000到5000个用户做这个。我是Python新手，是PBX工程师

我的代码和输出如下：

import requests
import xml.etree.ElementTree as ET

# this statement performs a GET on the specified url
response = requests.get('https://10.10.10.10:8443/cucm-uds/users?last=XXXXXX',verify=False, auth=('XXXXXX', 'XXXXXX'))


# print the json that is returned

print (response.text)

print('**********************')

#doc= print (response.text)

root = ET.fromstring(response.text)


for child in root:
     doc=print(child.tag)

for user in root.findall('user'):
    name=user.find('userName').text

print(name)

文件输出：

Warning (from warnings module):
  File "C:\Python34\lib\site-packages\requests\packages\urllib3\connectionpool.py", line 821
    InsecureRequestWarning)
InsecureRequestWarning: Unverified HTTPS request is being made. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.org/en/latest/security.html
Devices = 
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<users uri="https://10.10.10.10:8443/cucm-uds/users" version="10.5.2" start="0" requestedCount="64" returnedCount="1" totalCount="1">
    <user uri="https://10.10.10.10:8443/cucm-uds/user/taksh">
        <id>d96a9ee4-1992-4a37-b6dd-6c0702792e08</id>
        <userName>taksh</userName>
        <firstName>taksh</firstName>
        <lastName>XXXXXX</lastName>
        <middleName></middleName>
        <nickName></nickName>
        <phoneNumber>11111</phoneNumber>
        <homeNumber></homeNumber>
        <mobileNumber>+1-111-111-1111</mobileNumber>
    </user>
</users>



user

userName

taksh

Answer 1

你可以去图书馆看看

您的数据帧看起来与此类似：

df1 = pd.DataFrame( data={ "user":data1,"name":data2} )

其中data1、data2是包含解析后的结果的列表。 通过分析文件创建数据帧

>>> writer = ExcelWriter('output.xlsx')
>>> df1.to_excel(writer,'Sheet1')
>>> df2.to_excel(writer,'Sheet2')
>>> writer.save() 

你可以得到excel表格

要解析xml文档网，请通过以下链接

xml parsing