object doesn't Support this Property 'readAsBinaryString' ie

Question

am having Error In ie11 as the line of Code readAsBinaryString While Uploading Excel to Table

 

 

function ExportToTable() {

debugger;

var regex = /^([a-zA-Z0-9\s_\\.\-:])+(.xlsx|.xls)$/;

/*Checks whether the file is a valid excel file*/

if (regex.test($("#excelfile").val().toLowerCase())) {

var xlsxflag = false; /*Flag for checking whether excel is .xls format or .xlsx format*/

if ($("#excelfile").val().toLowerCase().indexOf(".xlsx") > 0) {

xlsxflag = true;

}

/*Checks whether the browser supports HTML5*/

if (typeof (FileReader) != "undefined") {

var reader = new FileReader();

reader.onload = function (e) {

debugger;

if (FileReader.prototype.readAsBinaryString === undefined) {

FileReader.prototype.readAsBinaryString = function (fileData) {

debugger;

var binary = "";

var pt = this;

var reader = new FileReader();

reader.onload = function (e) {

var bytes = new Uint8Array(reader.result);

var length = bytes.byteLength;

for (var i = 0; i < length; i++) {

binary += String.fromCharCode(bytes[i]);

}

//pt.result - readonly so assign content to another property

pt.content = binary;

pt.onload(); // thanks to @Denis comment

}

reader.readAsArrayBuffer(fileData);

}

}

if (!e) {

var data = reader.content;

}

else {

var data = e.target.result;

}

/*Converts the excel data in to object*/

if (xlsxflag) {

var workbook = XLSX.read(data, { type: 'binary' });

}

else {

var workbook = XLS.read(data, { type: 'binary' });

}

/*Gets all the sheetnames of excel in to a variable*/

var sheet_name_list = workbook.SheetNames;

var cnt = 0; /*This is used for restricting the script to consider only first sheet of excel*/

sheet_name_list.forEach(function (y) { /*Iterate through all sheets*/

/*Convert the cell value to Json*/

if (xlsxflag) {

var exceljson = XLSX.utils.sheet_to_json(workbook.Sheets[y]);

}

else {

var exceljson = XLS.utils.sheet_to_row_object_array(workbook.Sheets[y]);

}

if (exceljson.length > 0 && cnt == 0) {

BindTable(exceljson, '#exceltable');

cnt++;

}

});

$('#exceltable').show();

}

if (xlsxflag) {/*If excel file is .xlsx extension than creates a Array Buffer from excel*/

reader.readAsArrayBuffer($("#excelfile")[0].files[0]);

}

else {

reader.readAsBinaryString($("#excelfile")[0].files[0]);

}

}

else {

alert("Sorry! Your browser does not support HTML5!");

}

}

else {

alert("Please upload a valid Excel file!");

}

}