As we can send form data of HTML to excel.But how to use this stored excel data in HTML forms.

Question

we can add data to excel by using HTML but how we can use this stored data as our form data.please some one help me.

Answer 1

@Deepak, sure, if you use Node.js for the backend, there are a couple of libraries for doing this: js-xlsx and js-xls

Answer 2

@Deepak always a pleasure 😊👍

Answer 3

If you're planning on using an Excel file as your database then you'll need to handle it on the server side with PHP to connect your website with it, then with SQL you'd pull out the information you want from the Excel database and then make PHP output the result with HTML tags. There are lots of tutorials on the internet for doing this, for instance: http://smallbusiness.chron.com/populate-website-excel-database-43872.html ☺

Answer 4

@Deepak hmm, well PHP would be my first option in this case but another way I can think of is getting the data out from the Excel file using Python (with packages like pandas, xlwings, openpyxl, etc) and then write this data into an SQL database ☺

Answer 5

@Paola i try to aplly your advise. Thx thx thx!

Answer 6

Convert your web files using electron to desktop app, the software would be able to fetch local file then.

Answer 7

As we can feed data to excel by html without php.Then It is possible to use that stored data without using php