enter image description here
在此处输入图像描述
I have the Html from image, but I can't have the data from tbody. tbody is child <div><table id="grid1ContainerRow_001"><tbody>
, and the data it's organize in <tr><td>
.
我有来自图像的超文本标记语言,但我不能有来自tbody的数据。TBody是子,其组织数据是。
I found some scripts to get html tables, but all them get some error.
我找到了一些获取html表的脚本,但它们都出现了一些错误。
like this Google App Script parse table from messed html that return "Open quote is expected for attribute "tabindex" associated with an element type "form"."
与此类似,Google App脚本从混杂的html中解析表,返回“与元素类型”Form“”相关联的属性“tabindex”需要前引号。“
the table shows like that
enter image description here
该表显示了如下所示输入图像描述
And have an inconvenience because the table have next page continuation, so you need click "next page" button to have the complete data.
而且有一个不便,因为表格有下一页续页,所以需要点击“下一页”按钮才能拥有完整的数据。
The site has an Excel download option, but I want to have the data direct from web site, because it's updated some times.
该网站有一个Excel下载选项,但我想有数据直接从网站,因为它更新了一些时间。
If you want to see, here is the site table http://secure.senave.gov.py:8443/registros/servlet/com.consultaregistros2.prod_agro2
如果您想要查看,这里是站点表http://secure.senave.gov.py:8443/registros/servlet/com.consultaregistros2.prod_agro2
I want a form to get the table from the html site.
我想要一个表格,从html网站上获取表格。
EDIT 1
编辑1
I got the data from the first page
我从第一页就拿到了数据
function foo() {
var url = "http://secure.senave.gov.py:8443/registros/servlet/com.consultaregistros2.prod_agro2"
var page = UrlFetchApp.fetch(url).getBlob().getDataAsString()
var xd = [];
//Logger.log(page)
var Matrix = Parser.data(page).from(" value='").to("'/>").build();
xd = JSON.parse(Matrix)
plot_data_to_Spreadsheet(xd)
}
NOW I can´t scrap the complete table because it has "next" button to access the rest of them.
现在我不能删除整个表格,因为它有“下一步”按钮来访问其余的表格。
更多回答
我是一名优秀的程序员,十分优秀!