<script>
var tableobj=document.getElementById("tableid"); '注意tableid改成你的表格的id
for(i=1;i<tableobj.rows.length;i++)
{ result=0;
row=tableobj.rows[i];
for(r=1;r<row.cells.length;r++)
{
if(!isNaN(parseFloat(row.cells[r].innerText)))
{
//alert(row.cells[r].innerText);
result+=parseFloat(row.cells[r].innerText);
}
}
row.cells[row.cells.length-1].innerText=result/row.cells.length-2;
}
</script>
var tableobj=document.getElementById("tableid"); '注意tableid改成你的表格的id
for(i=1;i<tableobj.rows.length;i++)
{ result=0;
row=tableobj.rows[i];
for(r=1;r<row.cells.length;r++)
{
if(!isNaN(parseFloat(row.cells[r].innerText)))
{
//alert(row.cells[r].innerText);
result+=parseFloat(row.cells[r].innerText);
}
}
row.cells[row.cells.length-1].innerText=result/row.cells.length-2;
}
</script>
row.cells[row.cells.length-1].innerText=result/row.cells.length-2;
请改成
row.cells[row.cells.length-1].innerText=result/(row.cells.length-2);
var cols = 0;
var rowTs = 0;
for (var i = 1; i < tableId.rows.length; i++) {
for (var j = 1; j < 13; j++) {
if (!isNaN(tableId.rows(i).cells(j).innerHTML)) {
rowTs += parseFloat(tableId.rows(i).cells(j).innerHTML);
cols++;
}
}
tableId.rows(i).cells(j).innerHTML = rowTs/cols;
cols = 0;
rowTs = 0;
}
}
sum(t);