Android从网站中提取多个表格
Android从网站中提取多个表格
提问于 2018-09-20 05:56:46
在被困了几个星期之后，我能够自动登录一个网站，能够下载Excel文件，还能够查看网站正文。
我还有另外一个问题，希望你能帮忙。如何提取每个表？每个表的数据都将被插入到sqllite数据库中。以下是来自该网站的表格示例：
<tr class="odd">
<td colspan="10" style="text-align:center;font-
size:12px;font-weight:600;">
122 Address
</td>
</tr>
<tr class="odd">
<td>122Address</td>
<td>Guest Name/td>
<td>Aug 06 -- Sep 07</td>
<td>No</td>
<td>No</td>
<td>No</td>
<td>No</td>
<td>No</td>
09-19 17:11:36.396 14017-14017/com.pmapp.mikeys.propertymanagementapp
I/System.out: <td>No</td>
<td>Agent Name</td>
</tr>
<tr class="odd">
<td> </td>
<td colspan="9">Remarks</td>
</tr>
<tr class="even">
<td colspan="10" style="text-align:center;font-size:12px;font-weight:600;">
154 Address
</td>
</tr>
<tr class="even">
<td>154Address</td>
<td>Guest Name</td>
<td>Aug 30 -- Sep 02</td>
<td>No</td>
<td>No</td>
<td>No</td>
<td>No</td>
<td>No</td>
09-19 17:11:36.397 14017-14017/com.pmapp.mikeys.propertymanagementapp I/System.out: <td>No</td>
<td>Agent Name</td>
</tr>
<tr class="odd">
<td>154Address</td>
<td>Guest Name</td>
<td>Sep 07 -- Sep 09</td>
<td>No</td>
<td>No</td>
<td>No</td>
<td>No</td>
<td>No</td>
<td>No</td>
<td>Agent Name</td>
</tr>
<tr class="even">
<td>154Address</td>
<td>Guest Name</td>
<td>Sep 14 -- Sep 16</td>
<td>No</td>
<td>No</td>
<td>No</td>
<td>No</td>
09-19 17:11:36.398 14017-14017/com.pmapp.mikeys.propertymanagementapp
I/System.out: <td>No</td>
<td>No</td>
<td>Agent Name</td>
</tr>
<tr class="odd">
<td>154Address</td>
<td>Guest Name</td>
<td>Sep 16 -- Sep 19</td>
<td>No</td>
<td>No</td>
<td><div style="color:red;font-weight:600;">PH</div></td>
<td>No</td>
<td>No</td>
<td>No</td>
09-19 17:11:36.399 14017-14017/com.pmapp.mikeys.propertymanagementapp
I/System.out: <td>Agent Name/td>
</tr>
<tr class="odd">
<td> </td>
<td colspan="9">Remarks</td>
</tr>
<tr class="even">
<td>154Address</td>
<td>Guest Name</td>
<td>Sep 20 -- Sep 23</td>
<td>No</td>
<td>No</td>
<td><div style="color:red;font-weight:600;">PH</div></td>
<td>No</td>
09-19 17:11:36.400 14017-14017/com.pmapp.mikeys.propertymanagementapp
I/System.out: <td>No</td>
<td>No</td>
<td>Agent Name</td>
</tr>
<tr class="odd">
<td>154Address</td>
<td>Guest Name</td>
<td>Sep 28 -- Sep 30</td>
<td>No</td>
<td>No</td>
<td>No</td>
<td>No</td>
<td>No</td>
<td>No</td>
<td>Agent Name</td>
</tr>
09-19 17:11:36.401 14017-14017/com.pmapp.mikeys.propertymanagementapp
I/System.out:
<tr class="even">
<td>154Address</td>
<td>Guest Name</td>
<td>Sep 30 -- Oct 06</td>
<td>No</td>
<td>No</td>
<td><div style="color:red;font-weight:600;">PH</div></td>
<td><div style="color:red;font-weight:600;">GR</div></td>
<td>No</td>
<td>No</td>
<td>Agent Name</td>
</tr>
09-19 17:11:36.402 14017-14017/com.pmapp.mikeys.propertymanagementapp
I/System.out: <tr class="odd">
<td colspan="10" style="text-align:center;font-
size:12px;font-weight:600;">
165 Street address
</td>
</tr>
<tr class="odd">
<td>165Address</td>
<td>Guest Name</td>
<td>Sep 01 -- Sep 03</td>
<td>No</td>
<td>No</td>
<td>No</td>
<td>No</td>
<td>No</td>
<td>No</td>
<td>Agent Name</td>
</tr>希望你能帮上忙。因此，我将为每个项目创建一个变量，例如：
Address,
Guest Name,
Check In,
Check Out,
Early Arrival,
Late Departure,
Pool Heat,
Grill,
Crib,
High Chair,
Agent,
Remarks (if any)回答 1
Stack Overflow用户
发布于 2018-09-20 06:28:37
使用JSoup并按照他们的文档从DOM中获取表。在依赖项中添加compile 'org.jsoup:jsoup:1.11.3'
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/52414719
复制相关文章
相似问题