How to extract data from a table in excel using javascript?



  • Please help me, i am a beginner programmer that still lack in programming skill. I create a webpage using html and javascript. So the webpage is simple where user can find employee, startdate and endate. The table in excel has many contain but using this webpage, it only display data that the input as what user put in employeeid, startdate and endate searchbox. All the function i want to apply to a button. But, my idea suddenly stop when i dont have any idea to connect excel to my webpage. that why i ask about this matter.



  • This does not concern Notepad++ at all.



  • well it is… because im using notepad++ to create the webpage



  • @Camillia-Wee said in How to extract data from a table in excel using javascript?:

    because im using notepad++ to create the webpage

    Sorry, but I agree with @dail What you are really asking for is coding help in html and JavaScript. That fact that you’re using Notepad++ has little to do with it. You might get lucky with someone here willing to offer some guidance but I think you’d be better off asking this type of question in a html/JavaScript forum.

    Good luck
    Terry



  • @Terry-R okey… thank you



  • @Camillia-Wee

    This seems to be more of an Excel question than an html or javascript issue.

    Excel has a built-in language, Visual Basic for Applications or VBA, that you use to build forms and to import/export data. VBA is very different than JavaScript which is very different than HTML. Excel is also not connected to the Internet meaning you can’t directly have a web page that gets data from or puts data into a spreadsheet. You will go crazy try to learn all three at once combined with learning how to connect Excel to the Internet.

    Google for web front end to excel spreadsheet where people say how to do it. Many of the answers that Google finds look old and may not include that Microsoft has moved to Office 356 (which they now call Microsoft 365).

    You may also want to look into using Google sheets which is a web based thing that looks like Excel.

    As others noted, this has nothing to do with Notepad++ other than you can use Notepad++ to edit VBA code along with JavaScript and HTML. Good luck.



  • @Camillia-Wee said in How to extract data from a table in excel using javascript?:

    because im using notepad++ to create the webpage

    COOKIES!