There is a form to search

<input type="text" id="searchPhrase" />

and an excel file (.xls) on the server. How to use js to access this file and find matches with the phrase given in the form?

  • four
    In JS Ajax, make a request to the server by passing the necessary information in the request parameters. And on the server, organize the search by server tools. It may be worth thinking about transferring data from Excel to a SQL database. - Regent

1 answer 1

The general question, the general answer, I need a library, I chose xlsjs , from everything that was this turned out to be the most convenient and stable, then we do the server part, for example, I did on Node.js, parsim xls, I made JSON from it. and then I just searched using RegEXP and a cycle, in principle, the file for 700 lines is looking very briskly, even on CoreDuo 3GHz, in general, for good here is not to answer