CODEWITHSUNDEEP
javascripthtmlexcelurlsharepoint
Kieran Quinn
Kieran Quinn

Reputation: 1115

Open Excel file url in excel (from source, not downloaded copy)

In IE, it's quite easy to "Open in Excel" a url to a file on a network or internet location. Is the same possible in Chrome though? The file must be opened from its current location, not from a downloaded copy. So when the user saves any changes, they save to the original location. IE Tab isn't an option either, we cant install chrome extensions.

Things I've tried:

1) Web protocol: "ms-excel:ofe|u"

<a href="ms-excel:ofe|u|//server/folder/Test.xls">Open in Excel</a>

enter image description here

enter image description here

2) ActiveX (I know it wouldnt work with Chrome, adding for completeness)

<input type=button onClick="test()" value="javascript solution">

<script type="text/javascript">
    function test() {
        var Excel = new ActiveXObject("Excel.Application");
        Excel.Visible = true;
        Excel.Workbooks.Open("//server/folder/Test.xls");
    }
</script>

enter image description here

3) Direct link to the file:

<a href="//server/folder/Test.xls">Click</a><br />

This just downloads the file to the local machine and can be set to open as soon as it downloads, but changes are saved locally.

UPDATE: I've found that trying to access a file stored in sharepoint works using method 1 above.

<a href="ms-excel:ofe|u|http://sharepointserver/sites/rptserver/Test.xls">Open in Excel</a>

Any reason it would work for sharepoint files but not files stored in a network location?

UPDATE: I've found documentation for the ms-excel:ofe|u| web protocol which states that only http and https are supported.

*Bounty will only be awarded to answers to the specific question:

Is there any way to open a file in excel with chrome where the path to the file is a local or network storage location rather than a http/https url?

Upvotes: 8

Views: 7305

Answers (2)

MauriceNino
MauriceNino

Reputation: 6747

No it is not possible for security reasons. All newer browsers (and I guess even the newer implementations of IE), don't allow file access to the local system. Internet Explorer is the only browser that supports opening files from locations, that are seen and treated as local ones.

You can open files from a Webdav Server, which is probably, why you can access files from your SharePoint, so you could try mapping that provider of your network drive as a Webdav Server.

Source: https://www.codeproject.com/Questions/1180249/Open-edit-save-excel-sheet-from-browser-using-java AND Is there an Application URL Protocol for MS Word?

Upvotes: 6

Jin Thakur
Jin Thakur

Reputation: 2773

You upload your excel on Google drive and people can use it from google sheets. Browser functionality is to download the copy of file to local Computer. You should use File server FTP server and other Protocols to actually edit file at source. There are Web file manager software which can give you ability to save file. Try Cloud version of software etc to save file in web page and see the version history too. GitHub can have Private repository too.

Upvotes: 0

Related Questions