Convert html table to array in javascript
Here's one example of doing what you want.
var myTableArray = [];
$("table#cartGrid tr").each(function() {
var arrayOfThisRow = [];
var tableData = $(this).find('td');
if (tableData.length > 0) {
tableData.each(function() { arrayOfThisRow.push($(this).text()); });
myTableArray.push(arrayOfThisRow);
}
});
alert(myTableArray);
You could probably expand on this, say, using the text of the TH to instead create a key-value pair for each TD.
Since this implementation uses a multidimensional array, you can access a row and a td by doing something like this:
myTableArray[1][3] // Fourth td of the second tablerow
Edit: Here's a fiddle for your example: http://jsfiddle.net/PKB9j/1/
This a function coverts an Html Table (just give the id) and it returns an array of the table :
function table_to_array(table_id) {
myData = document.getElementById(table_id).rows
//console.log(myData)
my_liste = []
for (var i = 0; i < myData.length; i++) {
el = myData[i].children
my_el = []
for (var j = 0; j < el.length; j++) {
my_el.push(el[j].innerText);
}
my_liste.push(my_el)
}
return my_liste
}
I hope it helps you !
You can write also with key value pair. this is so simple.
function htmlTableDataToArrayOfObject(){
var arrayOfThisRow = [];
$("#cartGrid tbody tr").each(function() {
debugger;
var description = $(this).find('td:eq(0)').text();
var qty = $(this).find('td:eq(1)').text();
var unitPrice= $(this).find('td:eq(2)').text();
arrayOfThisRow.push({
desc: description,
quantity: qty,
price: unitPrice
});
});
}