How can I read Excel file using JavaScript?

Question

How can I read Excel file using javascript (without using ActiveXObject)?

Santosh Rajput · Answer

Thanks for the reply but I find out the solution here: https://github.com/SheetJS/js-xlsx

Amin Dodin · Answer

Web browsers on their own do not support viewing Excel files. If you want to display Excel files in a browser, you will need server-side code to render the pages, in addition to the JS code to display the rendered document. One way to do that is to use the Document Viewer SDK that's part of the LEADTOOLS Document Imaging toolkit. The SDK contains both JavaScript controls for use with the browser-side display, and services that run at the server side to handle different types of documents, like Excel, PDF and others. You can try the viewer using the online demo here: https://demo.leadtools.com/JavaScript/DocumentViewer/index.html You can also download the free evaluation of the toolkit, which includes the source code of the Document Viewer demo from this page: https://www.leadtools.com/downloads?category=main The following is the JavaScript code that loads the Excel file: var url = "https://serverAddres/sample.xls" ; var pts = null ; // Call the "LoadFromUri" and pass success and failure callbacks to the promise lt.Documents.DocumentFactory.loadFromUri(url, null ) .done( function (document) { // Set the document in the viewer _this.documentViewer.setDocument(document); var ImageViewer = _this.documentViewer.view.imageViewer; }

Nitin Sontakke · Answer

Do you mean in browser? From the disk of the user? If yes and yes, no you cannot do that due to security reason. If not the above scenario, please provide more details.

How can I read Excel file using JavaScript?

Answers (3)