Read csv file with javascript

Question

Currently im using this code to view content of a csv in a webbrowser with javascript. But this only works in firefox as other browser dont allow you to grab content from an iframe. I need to convert my csv to a txt if i want to use this method, and would like to keep csv instead of txt.

Do any of you know how I can make this work without the Iframe part and txt part so I can use it in different browser? Thanks!

<iframe id="frmFile" src="content/assets/output.txt" onload="LoadFile();" style="display: none;"></iframe>

<script>function LoadFile() {
var oFrame = document.getElementById("frmFile");
var strRawContents = oFrame.contentWindow.document.body.childNodes[0].innerHTML;

while (strRawContents.indexOf("\r") >= 0)
strRawContents = strRawContents.replace("\r", "");
var arrLines = strRawContents.split("\n");
var alltext = "";

if(arrLines[12].split(";")[8] == "0"){ }
for (var i = 1; i < arrLines.length; i++)
{
    alltext += "<tr>";
    var prop = arrLines[i].split(";");
    for (var j = 0; j < 11; j++) {
        alltext += "<td>" + prop[j] + "</td>";
    }
    alltext += "</tr>";
    document.close();
}
document.getElementById("message").innerHTML = alltext;
}
</script>

JordanGW · Accepted Answer · 2019-03-23 13:06:54Z

1

I would suggest Ajax get of the file -> that way you can get the text content.

<!-- no iframe -->

<script>
var url = "http://www.example.com/file.txt";
var txtFile = new XMLHttpRequest();
txtFile.open("GET",url,true);
txtFile.send();

txtFile.onreadystatechange = function(){
     if (txtFile.readyState== 4 && txtFile.status == 200)
     {              
         var strRawContents = jsonFile.responseText;
     }
}
</script>

edited Mar 23, 2019 at 13:06

JordanGW

1741 silver badge12 bronze badges

answered Jun 27, 2017 at 21:23

WuDo

1958 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Jeroen Over a year ago

Like this?: pastebin.com/raw/0xpCmgRE That gives this error: Uncaught ReferenceError: LoadFile is not defined at HTMLIFrameElement.onload

WuDo Over a year ago

Edited the response. It's done completely without iframe and response text is the text of file (now named the same way as you have).

Jeroen Over a year ago

Using your code it says: Uncaught SyntaxError: Unexpected token var Using this (pastebin.com/raw/Zw2q8JtZ) code I get: MLHttpRequest cannot load file:///C:/Users/Jay/test/etc/output.txt. Cross origin requests are only supported for protocol schemes: http, data, chrome, chrome-extension, https.

JordanGW Over a year ago

C'mon man at least sense check your code before posting. Half of the conditional statement is missing

Collectives™ on Stack Overflow

Read csv file with javascript

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related