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>

1个回答

 <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>

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问
相关内容推荐