<!doctype html>
<html>
<head>
<title>读取并解析csv</title>
</head>
<body>
<div>
读取文件:
<input type="file" id="file1" accept="*" />
</div>
<div>
显示进度:
<progress id="pro" value="0"></progress>
</div>
<div id="result"></div>
<script type="text/javascript">
var file1 = document.getElementById('file1');
file1.onchange = function () {
var file = file1.files[0];
//读取为二进制
var reader = new FileReader();
reader.readAsText(file,'utf-8');
//显示进度
var pro = document.getElementById('pro');
pro.max = file.size;
pro.value = 0;
reader.onprogress = function (e) {
pro.value = e.loaded;
}
reader.onload = function () {
var str = reader.result;
var rows = str.split('\n');
var clients = [];
for(var i =0; i<rows.length; i++){
var row =rows[i].split(',') ;
var client = {
Record:row[0],
Date:row[1],
UTCTime:row[2],
PressureValue:row[3],
Pressure:row[4],
coord:{x:row[5],y:row[6]}
};
clients.push(client);
}
//由对象转为JSON字符串
console.log(JSON.stringify(clients));
document.getElementById('result').innerHTML = JSON.stringify(clients);
//console.log(rows);
//document.getElementById('result').innerHTML = rows;
}
}
</script>
</body>
</html>