How to implement search in Excel files?

Question

PHP

Hello!
There is a set of 30-40 Excel files, which are the price lists of suppliers.
All price lists are very motley - everyone has different columns and product descriptions for each supplier in their own way
. What is the task?
Make a search through all these files (preferably a search from the web interface)
For example, I drive in "Carriage"
The result will be the output of lines from the price lists, if the search word is found in any cell of the line .
Accordingly, I can see which supplier gives the best price.
There are probably a lot of solutions, but so far I haven’t found anything worthwhile and easy to use (opensearchserver.com)

Answer 1

You can use elasticsearch , data from excel is driven into elastic (solutions are easily googled), and from the back it is already working with the search engine in accordance with the business logic