Computer Blog: Reading data from CSV File using JavaScript

Wednesday 30 January 2013

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Reading Data from CSV File</title>

div

{

float: left;

width: 250px;

}

</style>

function readCSVFile() {

var csvData = new Array();

var csvFilePath = "F:\\Data.csv";

var fso = new ActiveXObject('Scripting.FileSystemObject');

var iStream = fso.OpenTextFile(csvFilePath, 1, true, 0);

for (var n = 0; !iStream.AtEndOfStream; n++) {

csvData[n] = iStream.ReadLine();

showData(csvData[n]);

}

iStream.Close();

}

function showData(data) {

var csvData = data.split(",");

document.getElementById('firstNames').innerHTML += "<br />" + csvData[0];

document.getElementById('middleNames').innerHTML += "<br />" + csvData[1];

document.getElementById('lastNames').innerHTML += "<br />" + csvData[2];

}

</script>

</head>

<div id="firstNames"><b><i>First Names:</i></b></div>

<div id="middleNames"><b><i>Middle Names:</i></b></div>

<div id="lastNames"><b><i>Last Names:</i></b></div>

</body>

</html>

Note: This code works only in Internet Explorer