CODEWITHSUNDEEP
javascripthtmlexcel
user3321757
user3321757

Reputation: 41

Open Excel file instead of download using HTML and Javascript

Can anyone please suggest any idea about how to open an Excel file, kindly check below code and let me know how to achieve opening the instead of downloading the file.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<script type="text/javascript">

function read()  
{  
     var txtFile = new XMLHttpRequest();  
     txtFile.open("GET", "C:\Users\user-temp\Downloads\test.xlsx", true);  
     txtFile.onreadystatechange = function()   
     {  
          if (txtFile.readyState === 4)   
          {  
               // Makes sure the document is ready to parse.  
               if (txtFile.status === 200)   
               {  
                    // Makes sure it's found the file.  
                    document.getElementById("div").innerHTML = txtFile.responseText;  
               }  
          }  
     }  
     txtFile.send(null)  
}
</script>
</head>
<body onload="read();">  
<form id="form1" runat="server">  
   <div id="div">  
   </div>  
</form>

Upvotes: 2

Views: 4057

Answers (1)

sifr_dot_in
sifr_dot_in

Reputation: 3593

in your case you can use following methods
with google viewer iframe:

<iframe src="http://docs.google.com/gview?url=https://sifr.in/img/292/1/courseAndroid.xlsx&embedded=true"></iframe>

or with microsoft viewer iframe:

<iframe src='https://view.officeapps.live.com/op/embed.aspx?src=https://sifr.in/img/292/1/courseAndroid.xlsx'></iframe>

or open it in another tab / window with following:

<a href="http://docs.google.com/gview?url=https://sifr.in/img/292/1/courseAndroid.xlsx&embedded=true">Open your excel file</a>

credit must also go to
this guy

Upvotes: 2

Related Questions