IPL Player Scraper

iplPlayerScraper

function GetColumns(row, expectedColumns){
    var cells = row.querySelectorAll("td");
    if(cells.length != expectedColumns)
    {
        return null;
    }
    var columns = [];
    
    for(var i=0; i < cells.length;i++){
        columns.push(cells[i].innerHTML);
    }
    return columns;
}

function GetTableContents(rows, startIndex, expectedColumns){
    var tableContents = [];
    for(var i = startIndex; i < rows.length; i ++)
    {
        var rowContents = GetColumns(rows[i], expectedColumns);
        if(rowContents) tableContents.push(rowContents);
    }
    return tableContents;
}

var table = document.querySelector("#sheet0").querySelectorAll("tr");
var expectedColumns = table[0].querySelectorAll("td").length;

var iplTable = {};
iplTable.tableHeader = GetColumns(table[0], expectedColumns);
iplTable.tableData = GetTableContents(table, 1, expectedColumns);

var jsonString = JSON.stringify(iplTable);

var jsonObj = JSON.parse(jsonString);

console.log(jsonObj);