javascript - grabbing table from html using Google script - Stack Overflow

admin管理员组

文章数量:1312658

Hi I'm trying to grab this webpage and store it into a table... any table. I'm using Google script.

var fetchString="/"
var response = UrlFetchApp.fetch(fetchString);

I need some help on the code to get this started. I'm looking to grab the "Traffic Data" table. I would like to put it into an 2D array if possible.

Hi I'm trying to grab this webpage and store it into a table... any table. I'm using Google script.

var fetchString="http://www.airchina..cn/www/en/html/index/ir/traffic/"
var response = UrlFetchApp.fetch(fetchString);

I need some help on the code to get this started. I'm looking to grab the "Traffic Data" table. I would like to put it into an 2D array if possible.

• javascript
• html
• dom
• google-apps-script
• web-scraping

Share Improve this question Follow edited Jun 23, 2017 at 15:38 Wicket 38.4k99 gold badges7878 silver badges193193 bronze badges asked Feb 11, 2013 at 3:38 jasonjason 4,4792323 gold badges103103 silver badges153153 bronze badges

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 7

Google provides a XML parsing/manipulating service. You can use this to parse the html that is in that table.

One note, if you investigate where that html is actually ing from, you'll see that it's actually ing from a different url. http://www.airchina..cn/www/jsp/airlines_operating_data/exlshow_en.jsp

So here's what I got for you. It works pretty well. Hopefully this is enough of a start for you.

function fetchIt() {
  var fetchString="http://www.airchina..cn/www/jsp/airlines_operating_data/exlshow_en.jsp"
  var response = UrlFetchApp.fetch(fetchString);

  var xmlDoc = Xml.parse(response.getBlob().getDataAsString(),true);
  var b = xmlDoc.getElement().getElement("body");
  var table = b.getElement("div").getElement("div").getElement("div").getElements("div")[1].getElement("table");

  var rows = [];
  var trs = table.getElements("tr");
  for (var r=0,rlength=trs.length; r<rlength; r++) {
    var tds = trs[r].getElements("td");
    var row = [];
    for (var c=0,clength=tds.length; c<clength; c++) {
      row.push(tds[c].getText());
    }
    rows.push(row);
  }

  Logger.log(Utilities.jsonStringify(rows));

}

本文标签： javascriptgrabbing table from html using Google scriptStack Overflow