Read Excel file on page load from url and show contents

My question is regarding this article "Read Excel file using Javascript". It is very useful script and I was searching it from long time.

Basically, I want to open address.xlsx automatically and read it, when I open html file in browser, don't want to browse file and then read/show the Excel output. How can I do it.

If possible, I would like to add, an input text-box with ability of search excel data displayed table.


Asked by:- manjoo
: 6171 At:- 10/19/2020 12:38:14 PM
Javascript read excel javascript

3 Answers
profileImage Answered by:- vikas_jk

As you have not mentioned any code or what you have done until now, I can suggest you following steps:

1.On page load, fetch excel file URL and convert it into blob using JavaScript, refer

2.From Blob convert to binarystring

3. Once you have got the Binary string, you can pass this value in FileReader and then call GetTableFromExcel(Data) from above linked page method.

 var reader = new FileReader();

 reader.onload = function (e) {

That's it.

Regarding search on table, once data is loaded is table, use jQuery datatable, it will automatically add searching and sorting in table.


At:- 10/20/2020 7:46:55 AM

profileImage Answered by:- manjoo

Thanks for your reply here is code wherein i have to select/load excel file, I want to load file automatically on page load

<input id="x_x_upload" type="button" value="Upload">
<input id="x_x_fileUpload" type="file">

I want to load file:///D:/Addresses/address.xlxs files

At:- 10/20/2020 9:17:10 AM

profileImage Answered by:- vikas_jk

It is not possible to set input type file value on page load

You cannot set a value to an input[type=file] element, because its very dangerous for a user. If the browser allow to do this then everyone will be able to get the files from the system of the user of a website, which is totally irrelevant for a user's privacy.

You can refer it here


At:- 10/21/2020 11:31:23 AM

Login/Register to answer
Register directly by posting answer/details

Full Name *

Email *

By posting your answer you agree on privacy policy & terms of use