jquery计算表格列,求和
有时候,需要统计网页上数据总数,系统没有提供该功能,需要手动计算,于是设计了这段代码
效果展示:
核心代码:
$(function() {
var totalRow = 0;
$('#overTimes tr').each(function() {
$(this).find('td:eq(1)').each(function() {
totalRow += parseFloat($(this).text());
});
});
console.log('计算共有:' + totalRow + '小时');
});
代码示例:求表格第二例和
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title></title>
<script src="http://libs.baidu.com/jquery/2.0.0/jquery.min.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
$(function() {
var totalRow = 0;
$('#overTimes tr').each(function() {
$(this).find('td:eq(1)').each(function() {
totalRow += parseFloat($(this).text());
});
});
console.log('计算共有:' + totalRow + '小时');
});
</script>
</head>
<body>
<table id="overTimes" rules="all">
<tr>
<th>Header0</th>
<th>Header1</th>
<th>Header2</th>
<th>Header3</th>
<th>Header4</th>
</tr>
<tr>
<td>1.25</td>
<td>1.13</td>
<td>2</td>
<td>2.6</td>
<td>5.3</td>
</tr>
<tr>
<td>8.6</td>
<td>1.32</td>
<td>2.4</td>
<td>5.2</td>
<td>5.6</td>
</tr>
<tr>
<td>6.5</td>
<td>3</td>
<td>9.4</td>
<td>4.2</td>
<td>2.3</td>
</tr>
</table>
</body>
</html>