Skip to content

Instantly share code, notes, and snippets.

@chemiadel
Created March 22, 2018 21:22
Show Gist options
  • Save chemiadel/1cc1e58066c3c3f521f04b2703ec89eb to your computer and use it in GitHub Desktop.
Save chemiadel/1cc1e58066c3c3f521f04b2703ec89eb to your computer and use it in GitHub Desktop.
function importTable(URL,i) {
//Content
var resp=UrlFetchApp.fetch(URL).getContentText();
//Regex
var regT=/<table[^>]*>([\s\S]*?)<\/table[^>]*>/g;
var regR=/<tr[^>]*>([\s\S]*?)<\/tr[^>]*>/g;
var regC=/<t[^>]*>([\s\S]*?)<\/t[^>]*>/g;
//Get All Tables
var tables=resp.match(regT).map(function(val){
return val.replace(/<\/?table[^>]*>/g,'');
});
//Get Table in rows
var rows=tables[i].match(regR).map(function(val){
return val.replace(/<\/?tr[^>]*>/g,'');
});
//Fill Array
var arr=[];
for(var r in rows){
arr.push([]);
var row=rows[r].match(regC).map(function(val){
return val.replace(/<\/?t[^>]*>/g,'');
});
for(var c in row){
arr[arr.length-1].push(row[c].replace(/<\/?[^>]*>/g,''))
}
}
return arr;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment