0

I need to open an excel file in Excel online on a button click which I retrieves from Document library .

I have followed this, but it shows me an Error page like 'Item does not exist. It may have been deleted by another user.'

Please suggest.

  • Do you want to do by Code with JSOM or Rest ? Or just to do in OOB ? – Sukumar MS Mar 19 at 10:04
  • JSOM or REST both will work for me! – Tezz Chaudhary Mar 20 at 11:08
  • If OOB is available for this, then please do suggest... – Tezz Chaudhary Mar 20 at 11:18
  • With help of modern experience applied in your libraries you can open excel online. – Sukumar MS Mar 21 at 9:52
1

I have done it something like this, please suggest if this is a good approach or not?

excelOpen(objItems[i].__metadata.uri);
   <a id="openExcel" target="_blank" onclick=excelOpen("' + objItems[i].__metadata.uri + '");>Click to view </a>' + '</td>'; 

function excelOpen(path){//,type
var p = GetDocUID(path);
    p.done(function(_resultpath){
        $('#openExcel').attr('href',_resultpath.d.ServerRedirectedEmbedUrl);
     });
}
function GetDocUID(path){
var defReturn = $.Deferred();
var url = path+"?&$select=ServerRedirectedEmbedUrl";
console.log(url);
  $.ajax({
    url: url,
    type: "GET",
    headers: {
      "accept": "application/json;odata=verbose",
    },
    success: function(results) {
    defReturn.resolve(results);
    },
    error: function(error) {
      defReturn.reject(error);
      console.log("Error in getting List: " + listName);
    }
  });
return defReturn.promise();
}

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.