使用Ruby从网站捕获HTML表
转换HTML表格 into使用JSON，CSV和Excel电子表格 GrabzIt的Ruby API 在东部，请按照此处显示的示例操作。 但是，在开始之前，请记住 url_to_table, html_to_table or file_to_table 方法 save or save_to 必须调用方法来捕获表。 如果您想快速查看此服务是否适合您，可以尝试 捕获HTML表的实时演示 从URL。
基本选项
下面的示例转换指定网页中的第一个HTML表 intoa CSV文件。
grabzItClient.url_to_table("https://www.tesla.com")
# Then call the save or save_to method
grabzItClient.html_to_table("<html><body><table><tr><th>Name</th><th>Age</th></tr>
<tr><td>Tom</td><td>23</td></tr><tr><td>Nicola</td><td>26</td></tr>
</table></body></html>")
# Then call the save or save_to method
grabzItClient.file_to_table("tables.html")
# Then call the save or save_to method
如果您不想自动转换网页中的第一个表格，则可以指定 tableNumberToInclude 方法。 例如，指定2将转换网页中找到的第二个表。
grabzItClient = GrabzIt::Client.new("Sign in to view your Application Key", "Sign in to view your Application Secret")
options = GrabzIt::TableOptions.new()
options.tableNumberToInclude = 2
grabzItClient.url_to_table("https://www.tesla.com", options)
# Then call the save or save_to method
grabzItClient.save_to("result.csv"
grabzItClient = GrabzIt::Client.new("Sign in to view your Application Key", "Sign in to view your Application Secret")
options = GrabzIt::TableOptions.new()
options.tableNumberToInclude = 2
grabzItClient.html_to_table("<html><body><table><tr><th>Name</th><th>Age</th></tr>
<tr><td>Tom</td><td>23</td></tr><tr><td>Nicola</td><td>26</td></tr>
</table></body></html>", options)
# Then call the save or save_to method
grabzItClient.save_to("result.csv")
grabzItClient = GrabzIt::Client.new("Sign in to view your Application Key", "Sign in to view your Application Secret")
options = GrabzIt::TableOptions.new()
options.tableNumberToInclude = 2
grabzItClient.file_to_table("tables.html", options)
# Then call the save or save_to method
grabzItClient.save_to("result.csv")
您还可以指定 targetElement 确保只转换指定元素ID中的表的方法。
grabzItClient = GrabzIt::Client.new("Sign in to view your Application Key", "Sign in to view your Application Secret")
options = GrabzIt::TableOptions.new()
options.targetElement = "stocks_table"
grabzItClient.url_to_table("https://www.tesla.com", options)
# Then call the save or save_to method
grabzItClient.save_to("result.csv")
grabzItClient = GrabzIt::Client.new("Sign in to view your Application Key", "Sign in to view your Application Secret")
options = GrabzIt::TableOptions.new()
options.targetElement = "stocks_table"
grabzItClient.html_to_table("<html><body><table id='stocks_table'><tr><th>Name</th><th>Age</th></tr>
<tr><td>Tom</td><td>23</td></tr><tr><td>Nicola</td><td>26</td></tr>
</table></body></html>", options)
# Then call the save or save_to method
grabzItClient.save_to("result.csv")
grabzItClient = GrabzIt::Client.new("Sign in to view your Application Key", "Sign in to view your Application Secret")
options = GrabzIt::TableOptions.new()
options.targetElement = "stocks_table"
grabzItClient.file_to_table("tables.html", options)
# Then call the save or save_to method
grabzItClient.save_to("result.csv")
如果您使用XLSX格式，则可以通过将true传递给 includeAllTables 方法。 然后，这会将每个表放在电子表格工作簿的新工作表中。
grabzItClient = GrabzIt::Client.new("Sign in to view your Application Key", "Sign in to view your Application Secret")
options = GrabzIt::TableOptions.new()
options.format = "xlsx"
options.includeAllTables = true
grabzItClient.url_to_table("https://www.tesla.com", options)
# Then call the save or save_to method
grabzItClient.save_to("result.xlsx")
grabzItClient = GrabzIt::Client.new("Sign in to view your Application Key", "Sign in to view your Application Secret")
options = GrabzIt::TableOptions.new()
options.format = "xlsx"
options.includeAllTables = true
grabzItClient.html_to_table("<html><body><table><tr><th>Name</th><th>Age</th></tr>
<tr><td>Tom</td><td>23</td></tr><tr><td>Nicola</td><td>26</td></tr>
</table></body></html>", options)
# Then call the save or save_to method
grabzItClient.save_to("result.xlsx")
grabzItClient = GrabzIt::Client.new("Sign in to view your Application Key", "Sign in to view your Application Secret")
options = GrabzIt::TableOptions.new()
options.format = "xlsx"
options.includeAllTables = true
grabzItClient.file_to_table("tables.html", options)
# Then call the save or save_to method
grabzItClient.save_to("result.xlsx")
将HTML表转换为JSON
借助GrabzIt，Ruby可以轻松转换HTML表 into JSON来指定 json 在format参数中。 在下面的示例中，读取了数据 同步地 通过使用 save_to 方法，将JSON作为 string。 然后可以通过类似的库来解析 json宝石.
grabzItClient = GrabzIt::Client.new("Sign in to view your Application Key", "Sign in to view your Application Secret")
options = GrabzIt::TableOptions.new()
options.format = "json"
options.tableNumberToInclude = 1
grabzItClient.url_to_table("https://www.tesla.com", options)
json = grabzItClient.save_to()
grabzItClient = GrabzIt::Client.new("Sign in to view your Application Key", "Sign in to view your Application Secret")
options = GrabzIt::TableOptions.new()
options.format = "json"
options.tableNumberToInclude = 1
grabzItClient.html_to_table("<html><body><table><tr><th>Name</th><th>Age</th></tr>
<tr><td>Tom</td><td>23</td></tr><tr><td>Nicola</td><td>26</td></tr>
</table></body></html>", options)
json = grabzItClient.save_to()
grabzItClient = GrabzIt::Client.new("Sign in to view your Application Key", "Sign in to view your Application Secret")
options = GrabzIt::TableOptions.new()
options.format = "json"
options.tableNumberToInclude = 1
grabzItClient.file_to_table("tables.html", options)
json = grabzItClient.save_to()
自订识别码
您可以将自定义标识符传递给 表 方法，如下所示，然后将该值返回给您的GrabzIt Ruby处理程序。 例如，该自定义标识符可以是数据库标识符，从而允许将屏幕截图与特定数据库记录相关联。
grabzItClient = GrabzIt::Client.new("Sign in to view your Application Key", "Sign in to view your Application Secret")
options = GrabzIt::TableOptions.new()
options.customId = "123456"
grabzItClient.url_to_table("https://www.tesla.com", options)
# Then call the save method
grabzItClient.save("http://www.example.com/handler/index")
grabzItClient = GrabzIt::Client.new("Sign in to view your Application Key", "Sign in to view your Application Secret")
options = GrabzIt::TableOptions.new()
options.customId = "123456"
grabzItClient.html_to_table("<html><body><h1>Hello World!</h1></body></html>", options)
# Then call the save method
grabzItClient.save("http://www.example.com/handler/index")
grabzItClient = GrabzIt::Client.new("Sign in to view your Application Key", "Sign in to view your Application Secret")
options = GrabzIt::TableOptions.new()
options.customId = "123456"
grabzItClient.file_to_table("example.html", options)
# Then call the save method
grabzItClient.save("http://www.example.com/handler/index")