金樽清酒斗十千 2017-04-05 09:27 采纳率: 0%
浏览 1509

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条回答 默认 最新

  • 金樽清酒斗十千 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>
    
    
    评论

报告相同问题?

悬赏问题

  • ¥15 安卓adb backup备份应用数据失败
  • ¥15 eclipse运行项目时遇到的问题
  • ¥15 关于#c##的问题:最近需要用CAT工具Trados进行一些开发
  • ¥15 南大pa1 小游戏没有界面,并且报了如下错误,尝试过换显卡驱动,但是好像不行
  • ¥15 没有证书,nginx怎么反向代理到只能接受https的公网网站
  • ¥50 成都蓉城足球俱乐部小程序抢票
  • ¥15 yolov7训练自己的数据集
  • ¥15 esp8266与51单片机连接问题(标签-单片机|关键词-串口)(相关搜索:51单片机|单片机|测试代码)
  • ¥15 电力市场出清matlab yalmip kkt 双层优化问题
  • ¥30 ros小车路径规划实现不了,如何解决?(操作系统-ubuntu)