xpath匹配文本，并导出到excel

需要提取Product,Enabled Users下的内容,并让（比如：Web Reporter和右面的Enabled Users对应起来）目的就是要看一个product后面有多少用户。

图片说明

 <DIV CLASS="page">
<br>
<span class="boldblack">Auditing Details</span>
</br>
<span class="boldblack">Project Source:</span><span class="normblack"> FHD_Product<BR>
</span>
<br>
<table cellspacing="0" cellpadding="2" width="80%" border="1" align="center">
<tr>
<td class="topth2">Product</td><td class="topth2">Enabled Users</td><td class="topth2">Disabled Users</td>
</tr>
<tr>
<td class="topth2">Web Reporter</td><td class="normtd">Allen Kong(allenk)<BR>Bounty Tian(bounty)<BR>Leo Kuang(leok)<BR>Lifang Liu(lifangl)<BR>linda ren(linda)<BR>lingling cao(linglingc)<BR>liping liu(lipingl)<BR>Peng Peng(pengp)<BR>Ping Liu(pingl)<BR>test(test)<BR>test_1(test_1)<BR>Wanyuan Li(wanyuanl)<BR>chao fu(chaof)<BR>Web User(chasity)<BR>Web User(huaixin)<BR>xue li(xuel1)<BR>yanhe(yanh1)<BR>yanqi li(yanqil)<BR>Yaqin Zhang(yaqinz)<BR>ying tian(yingt)<BR>Yuehua Zhang(yuehuaz)<BR>Zaixianpinkong(zaixianpinkong)<BR>dawei li(daweil)<BR>Hong Deng(hongd)<BR>Huiying Zhu(huiyingz)<BR>jiahuan liu(jiahuanl)<BR>Jie Zhou(jiez)<BR>John Zheng(johnz)<BR>Le Chang(lec)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Web Analyst</td><td class="normtd">Bounty Tian(bounty)<BR>Leo Kuang(leok)<BR>test(test)<BR>test_1(test_1)<BR>Web User(chasity)<BR>Web User(huaixin)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Web Professional</td><td class="normtd">Bounty Tian(bounty)<BR>Leo Kuang(leok)<BR>test_1(test_1)<BR>Web User(chasity)<BR>Web User(huaixin)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Office</td><td class="normtd">-<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Mobile Server</td><td class="normtd">-<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">MultiSource</td><td class="normtd">Bounty Tian(bounty)<BR>test(test)<BR>test_1(test_1)<BR>Web User(chasity)<BR>Web User(huaixin)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Distribution Services</td><td class="normtd">
<div class="smallblack bold">Users</div>Allen Kong(allenk)<BR>Bounty Tian(bounty)<BR>Leo Kuang(leok)<BR>Lifang Liu(lifangl)<BR>linda ren(linda)<BR>lingling cao(linglingc)<BR>liping liu(lipingl)<BR>Peng Peng(pengp)<BR>Ping Liu(pingl)<BR>test(test)<BR>test_1(test_1)<BR>Wanyuan Li(wanyuanl)<BR>chao fu(chaof)<BR>Web User(chasity)<BR>Web User(huaixin)<BR>xue li(xuel1)<BR>yanhe(yanh1)<BR>yanqi li(yanqil)<BR>Yaqin Zhang(yaqinz)<BR>ying tian(yingt)<BR>Yuehua Zhang(yuehuaz)<BR>Zaixianpinkong(zaixianpinkong)<BR>dawei li(daweil)<BR>Hong Deng(hongd)<BR>Huiying Zhu(huiyingz)<BR>jiahuan liu(jiahuanl)<BR>Jie Zhou(jiez)<BR>John Zheng(johnz)<BR>Le Chang(lec)<BR>
<div class="smallblack bold">Contacts</div>-<BR>
</td><td class="normtd">
<div class="smallblack bold">Users</div>-<BR>
<div class="smallblack bold">Contacts</div>-<BR>
</td>
</tr>
<tr>
<td class="topth2">Transaction Services</td><td class="normtd">Allen Kong(allenk)<BR>Bounty Tian(bounty)<BR>Leo Kuang(leok)<BR>linda ren(linda)<BR>lingling cao(linglingc)<BR>liping liu(lipingl)<BR>Peng Peng(pengp)<BR>test(test)<BR>test_1(test_1)<BR>Wanyuan Li(wanyuanl)<BR>Web User(chasity)<BR>Web User(huaixin)<BR>chao fu(chaof)<BR>xue li(xuel1)<BR>yanhe(yanh1)<BR>yanqi li(yanqil)<BR>Yaqin Zhang(yaqinz)<BR>Yuehua Zhang(yuehuaz)<BR>Zaixianpinkong(zaixianpinkong)<BR>dawei li(daweil)<BR>Hong Deng(hongd)<BR>Huiying Zhu(huiyingz)<BR>jiahuan liu(jiahuanl)<BR>Jie Zhou(jiez)<BR>John Zheng(johnz)<BR>Le Chang(lec)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Command Manager</td><td class="normtd">-<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Object Manager</td><td class="normtd">-<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Analyst</td><td class="normtd">Bounty Tian(bounty)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Developer</td><td class="normtd">Bounty Tian(bounty)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Architect</td><td class="normtd">Leo Kuang(leok)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Integrity Manager</td><td class="normtd">-<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">OLAP Services</td><td class="normtd">Allen Kong(allenk)<BR>Bounty Tian(bounty)<BR>Leo Kuang(leok)<BR>Lifang Liu(lifangl)<BR>linda ren(linda)<BR>lingling cao(linglingc)<BR>liping liu(lipingl)<BR>Peng Peng(pengp)<BR>Ping Liu(pingl)<BR>test(test)<BR>test_1(test_1)<BR>Wanyuan Li(wanyuanl)<BR>chao fu(chaof)<BR>Web User(chasity)<BR>Web User(huaixin)<BR>xue li(xuel1)<BR>yanhe(yanh1)<BR>yanqi li(yanqil)<BR>Yaqin Zhang(yaqinz)<BR>ying tian(yingt)<BR>Yuehua Zhang(yuehuaz)<BR>Zaixianpinkong(zaixianpinkong)<BR>dawei li(daweil)<BR>Hong Deng(hongd)<BR>Huiying Zhu(huiyingz)<BR>jiahuan liu(jiahuanl)<BR>Jie Zhou(jiez)<BR>John Zheng(johnz)<BR>Le Chang(lec)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Report Services</td><td class="normtd">Allen Kong(allenk)<BR>Bounty Tian(bounty)<BR>Leo Kuang(leok)<BR>Lifang Liu(lifangl)<BR>linda ren(linda)<BR>lingling cao(linglingc)<BR>liping liu(lipingl)<BR>Peng Peng(pengp)<BR>Ping Liu(pingl)<BR>test(test)<BR>test_1(test_1)<BR>Wanyuan Li(wanyuanl)<BR>chao fu(chaof)<BR>Web User(chasity)<BR>Web User(huaixin)<BR>xue li(xuel1)<BR>yanhe(yanh1)<BR>yanqi li(yanqil)<BR>Yaqin Zhang(yaqinz)<BR>ying tian(yingt)<BR>Yuehua Zhang(yuehuaz)<BR>Zaixianpinkong(zaixianpinkong)<BR>dawei li(daweil)<BR>Hong Deng(hongd)<BR>Huiying Zhu(huiyingz)<BR>jiahuan liu(jiahuanl)<BR>Jie Zhou(jiez)<BR>John Zheng(johnz)<BR>Le Chang(lec)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Desktop</td><td class="normtd">Bounty Tian(bounty)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Users without license association</td><td class="normtd">-<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
</table>
<BR>
</DIV>

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答

金樽清酒斗十千 2017-04-05 09:29

关注

 <DIV CLASS="page">
<br>
<span class="boldblack">Auditing Details</span>
</br>
<span class="boldblack">Project Source:</span><span class="normblack"> FHD_Product<BR>
</span>
<br>
<table cellspacing="0" cellpadding="2" width="80%" border="1" align="center">
<tr>
<td class="topth2">Product</td><td class="topth2">Enabled Users</td><td class="topth2">Disabled Users</td>
</tr>
<tr>
<td class="topth2">Web Reporter</td><td class="normtd">Allen Kong(allenk)<BR>Bounty Tian(bounty)<BR>Leo Kuang(leok)<BR>Lifang Liu(lifangl)<BR>linda ren(linda)<BR>lingling cao(linglingc)<BR>liping liu(lipingl)<BR>Peng Peng(pengp)<BR>Ping Liu(pingl)<BR>test(test)<BR>test_1(test_1)<BR>Wanyuan Li(wanyuanl)<BR>chao fu(chaof)<BR>Web User(chasity)<BR>Web User(huaixin)<BR>xue li(xuel1)<BR>yanhe(yanh1)<BR>yanqi li(yanqil)<BR>Yaqin Zhang(yaqinz)<BR>ying tian(yingt)<BR>Yuehua Zhang(yuehuaz)<BR>Zaixianpinkong(zaixianpinkong)<BR>dawei li(daweil)<BR>Hong Deng(hongd)<BR>Huiying Zhu(huiyingz)<BR>jiahuan liu(jiahuanl)<BR>Jie Zhou(jiez)<BR>John Zheng(johnz)<BR>Le Chang(lec)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Web Analyst</td><td class="normtd">Bounty Tian(bounty)<BR>Leo Kuang(leok)<BR>test(test)<BR>test_1(test_1)<BR>Web User(chasity)<BR>Web User(huaixin)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Web Professional</td><td class="normtd">Bounty Tian(bounty)<BR>Leo Kuang(leok)<BR>test_1(test_1)<BR>Web User(chasity)<BR>Web User(huaixin)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Office</td><td class="normtd">-<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Mobile Server</td><td class="normtd">-<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">MultiSource</td><td class="normtd">Bounty Tian(bounty)<BR>test(test)<BR>test_1(test_1)<BR>Web User(chasity)<BR>Web User(huaixin)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Distribution Services</td><td class="normtd">
<div class="smallblack bold">Users</div>Allen Kong(allenk)<BR>Bounty Tian(bounty)<BR>Leo Kuang(leok)<BR>Lifang Liu(lifangl)<BR>linda ren(linda)<BR>lingling cao(linglingc)<BR>liping liu(lipingl)<BR>Peng Peng(pengp)<BR>Ping Liu(pingl)<BR>test(test)<BR>test_1(test_1)<BR>Wanyuan Li(wanyuanl)<BR>chao fu(chaof)<BR>Web User(chasity)<BR>Web User(huaixin)<BR>xue li(xuel1)<BR>yanhe(yanh1)<BR>yanqi li(yanqil)<BR>Yaqin Zhang(yaqinz)<BR>ying tian(yingt)<BR>Yuehua Zhang(yuehuaz)<BR>Zaixianpinkong(zaixianpinkong)<BR>dawei li(daweil)<BR>Hong Deng(hongd)<BR>Huiying Zhu(huiyingz)<BR>jiahuan liu(jiahuanl)<BR>Jie Zhou(jiez)<BR>John Zheng(johnz)<BR>Le Chang(lec)<BR>
<div class="smallblack bold">Contacts</div>-<BR>
</td><td class="normtd">
<div class="smallblack bold">Users</div>-<BR>
<div class="smallblack bold">Contacts</div>-<BR>
</td>
</tr>
<tr>
<td class="topth2">Transaction Services</td><td class="normtd">Allen Kong(allenk)<BR>Bounty Tian(bounty)<BR>Leo Kuang(leok)<BR>linda ren(linda)<BR>lingling cao(linglingc)<BR>liping liu(lipingl)<BR>Peng Peng(pengp)<BR>test(test)<BR>test_1(test_1)<BR>Wanyuan Li(wanyuanl)<BR>Web User(chasity)<BR>Web User(huaixin)<BR>chao fu(chaof)<BR>xue li(xuel1)<BR>yanhe(yanh1)<BR>yanqi li(yanqil)<BR>Yaqin Zhang(yaqinz)<BR>Yuehua Zhang(yuehuaz)<BR>Zaixianpinkong(zaixianpinkong)<BR>dawei li(daweil)<BR>Hong Deng(hongd)<BR>Huiying Zhu(huiyingz)<BR>jiahuan liu(jiahuanl)<BR>Jie Zhou(jiez)<BR>John Zheng(johnz)<BR>Le Chang(lec)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Command Manager</td><td class="normtd">-<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Object Manager</td><td class="normtd">-<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Analyst</td><td class="normtd">Bounty Tian(bounty)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Developer</td><td class="normtd">Bounty Tian(bounty)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Architect</td><td class="normtd">Leo Kuang(leok)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Integrity Manager</td><td class="normtd">-<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">OLAP Services</td><td class="normtd">Allen Kong(allenk)<BR>Bounty Tian(bounty)<BR>Leo Kuang(leok)<BR>Lifang Liu(lifangl)<BR>linda ren(linda)<BR>lingling cao(linglingc)<BR>liping liu(lipingl)<BR>Peng Peng(pengp)<BR>Ping Liu(pingl)<BR>test(test)<BR>test_1(test_1)<BR>Wanyuan Li(wanyuanl)<BR>chao fu(chaof)<BR>Web User(chasity)<BR>Web User(huaixin)<BR>xue li(xuel1)<BR>yanhe(yanh1)<BR>yanqi li(yanqil)<BR>Yaqin Zhang(yaqinz)<BR>ying tian(yingt)<BR>Yuehua Zhang(yuehuaz)<BR>Zaixianpinkong(zaixianpinkong)<BR>dawei li(daweil)<BR>Hong Deng(hongd)<BR>Huiying Zhu(huiyingz)<BR>jiahuan liu(jiahuanl)<BR>Jie Zhou(jiez)<BR>John Zheng(johnz)<BR>Le Chang(lec)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Report Services</td><td class="normtd">Allen Kong(allenk)<BR>Bounty Tian(bounty)<BR>Leo Kuang(leok)<BR>Lifang Liu(lifangl)<BR>linda ren(linda)<BR>lingling cao(linglingc)<BR>liping liu(lipingl)<BR>Peng Peng(pengp)<BR>Ping Liu(pingl)<BR>test(test)<BR>test_1(test_1)<BR>Wanyuan Li(wanyuanl)<BR>chao fu(chaof)<BR>Web User(chasity)<BR>Web User(huaixin)<BR>xue li(xuel1)<BR>yanhe(yanh1)<BR>yanqi li(yanqil)<BR>Yaqin Zhang(yaqinz)<BR>ying tian(yingt)<BR>Yuehua Zhang(yuehuaz)<BR>Zaixianpinkong(zaixianpinkong)<BR>dawei li(daweil)<BR>Hong Deng(hongd)<BR>Huiying Zhu(huiyingz)<BR>jiahuan liu(jiahuanl)<BR>Jie Zhou(jiez)<BR>John Zheng(johnz)<BR>Le Chang(lec)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Desktop</td><td class="normtd">Bounty Tian(bounty)<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
<tr>
<td class="topth2">Users without license association</td><td class="normtd">-<BR>
</td><td class="normtd">-<BR>
</td>
</tr>
</table>
<BR>
</DIV>

报告相同问题？

关注问题

python 爬虫并保存到excel文件 python 爬虫
2023-02-01 15:25

回答 3 已采纳我用的edge，你改成chrome应该一样的 import time from lxml import etree from selenium import webdriver import pan
xpath提取不到 text 文本 python 有问必答
2021-07-19 17:03

回答 4 已采纳选取其所在标签，然后用text属性获取其下所有文本值。 txt='''<div class='item'> <span class="p1">制片国家/地区:</span
python的xpath表达式无法获取文本 python 数据挖掘
2021-11-22 20:58

回答 2 已采纳表达式有问题，这个html源码你用xpath取得话是有两个值的，所以索引0是搜不到。正确写法应该是把0换成2
使用python爬取网站数据并写入到excel中
2022-03-01 17:27

呜昂王0521的博客文章目录前言一、使用python爬取网上数据并写入到excel中例子一：例子二：二、工具类总结前言记录一下使用python将网页上的数据写入到excel中一、使用python爬取网上数据并写入到excel中要爬取数据的网站： ...
python xpath对孙节点内容进行匹配问题 python
2021-03-23 22:38

回答 1 已采纳用following定位，把前面设为顶节点，following后利用属性值再定位子孙节点。 url_cited_post = res_html.xpath( './/div[contain
xpath爬取图片，得不到src ，python求解决 python 有问必答爬虫
2022-01-27 12:25

回答 4 已采纳图片是js解析出来的，xpath无效，数据在js变量里面，正则提取下数据用json.loads加载获取代码如下 import requests import re import json def
用xpath爬取文本时如何去掉非文本内容 python 爬虫
2021-12-18 14:35

回答 1 已采纳 discribe =html.xpath('normalize-space(//div[@class="container-fluid"]//div[@class="work_b"]//text()
python | 尝试爬虫 xpath
2022-04-19 23:04

菜鸡小张1015的博客查看网页HTML的里面的或者在控制台（console）输入 document.charset 或者直接在python中查询response.encoding 第三部分：数据提取Xpath 数据提取方式：Xpath、beautifulsoup4、正则匹配（这里有一个正则匹配的...
使用xpath匹配的结果却为空？ python
2018-06-24 16:28

回答 4 已采纳建议用selenium的选择器匹配模式匹配，可以直接通过id或者class名字找到路径，xpath经常匹配不出来，再就是查看获取的网页类容中是否和看到的页面一致，有些会动态渲染
python爬虫关于xpath提取出来为空列表的问题 python 有问必答爬虫
2021-09-30 17:40

回答 2 已采纳你检查下这个网页中的内容是不是通过js代码读取外部json数据来动态更新的。requests只能获取网页的静态源代码，动态更新的内容取不到。对于动态更新的内容要用selenium 来爬取。或者是通
python如何用xpath取两个标签之间的内容 python 爬虫
2022-05-18 17:43

回答 3 已采纳 //span[text()="名字:"]/following::a[position()<count(//span[text()="名字:"]/following::a)-count(//spa
python爬虫04 - xpath和lxml模块
2020-08-26 23:15

烈风回响的博客 1. xpath介绍 1.1 基本概念 • XPath（XML Path Language）...lxml是python中的一个包，这个包中包含了将html文本转成xml对象，和对对象执行xpath的功能 1.2 结点的关系 xml_content = ''' <bookstore> <book
selenium获取的网页文本怎么装入excel中 python 有问必答
2021-07-07 11:15

回答 1 已采纳参考一下：https://blog.csdn.net/u013250071/article/details/81911434 如果对你有帮助，可以点击我这个回答右上方的【采纳】按钮，给我个采纳吗，谢谢
Requests+Xpath 爬取豆瓣读书TOP并生成txt,csv,json,excel文件
2021-07-01 17:41

雪小妮的博客说明： ...1 Requests+Xpath 爬取豆瓣读书TOP ‘’’ ...获取元素的Xpath信息并获得文本：手动获取：定位目标元素，在网站上依次点击：右键 > 检查 file=s.xpath(‘元素的Xpath信息/text()’) 快捷键
Python生成个人CSDN历史博客文章列表及目录
2023-01-15 20:30

程序媛一枚~的博客 # 使用Python构建CSDN历史博客文章列表，并生成目录
没有解决我的问题, 去提问

悬赏问题

¥15 Python时间序列如何拟合疏系数模型
¥15 求学软件的前人们指明方向🥺
¥50 如何增强飞上天的树莓派的热点信号强度，以使得笔记本可以在地面实现远程桌面连接
¥15 MCNP里如何定义多个源？
¥20 双层网络上信息-疾病传播
¥50 paddlepaddle pinn
¥20 idea运行测试代码报错问题
¥15 网络监控：网络故障告警通知
¥15 django项目运行报编码错误
¥15 STM32驱动继电器

码龄粉丝数原力等级 --

xpath匹配文本，并导出到excel

1条回答

码龄粉丝数原力等级 --

悬赏问题