ajax request to download an excel file is showing me truncated response

Question

I am trying to download an Excel file using Ajax (XMLHttpRequest).

On completion the responseText is found to have just 5 characters.
The network sniffing tool (Fiddler) is showing me that my computer received the entire file..

so why is the responseText showing me only 5 characters? I have tried both Synch and Asynch calls.

Thanks for any help you can give here.

var xmlHttpReq = getXmlHttpRequestObject();

function  getXmlHttpRequestObject(){
    var xmlhttp;

    if (window.XMLHttpRequest){// code for all new browsers
          xmlhttp=new XMLHttpRequest();

    }else if (window.ActiveXObject){// code for IE5 and IE6
         // xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");

        progids = ['MSXML2.XMLHTTP.6.0', 'MSXML2.XMLHTTP.3.0', 'Microsoft.XMLHTTP'];

        for (i=0 ; i < progids.length; i ++){
            try {
                xmlhttp = new window.ActiveXObject(progids[i]);
                break;
            } catch (e) {
              //do nothing
            }
        }


    }


    return xmlhttp;


}

//utility method for http get
function doSynchronousGet(url){
    if(xmlHttpReq == null){
        xmlHttpReq = getXmlHttpRequestObject();
    }

    //change last param to true for making async calls.
    xmlHttpReq.open("GET" ,url,false);
    xmlHttpReq.setRequestHeader("Connection", "close");
    xmlHttpReq.send(null);
    return xmlHttpReq.responseText;
}



var resultText = doSynchronousGet(url);

alert('resultText length: '+ resultText.length);
alert('resultText: '+ resultText);

score 1 · Accepted Answer · edited May 23 '17 at 12:19

1

The issue is probably that XMLHttpRequest doesn't ususally take binary data like an Excel file. If you just want to let the user download the file, read Ramiz's post. If you need to read the data in JavaScript, try switching to a text format like CSV (or better for parsing, JSON). If you really need to read a binary file, there are discussions of that here and here.

edited May 23 '17 at 12:19

Community

1
1

answered Dec 22 '09 at 06:13

Annie

6,621
22
27

Thanks so much for providing those two links. I am using the VBscript solution which allows us to get a handle on the responseBody. and then read in the bytes out of it. Its working great. – rk2010 Dec 22 '09 at 15:29
Where is Ramiz's post? – Derrick Apr 04 '16 at 16:04

score 0 · Answer 2 · answered Dec 22 '09 at 05:13

0

Do not use Ajax call (xmlhttprequest) to download/upload files. Better do it on server side.

answered Dec 22 '09 at 05:13

Krunal

3,443
3
23
27

ajax request to download an excel file is showing me truncated response

2 Answers2

Linked