Dynamic link between site and excel file?

Question

JavaScript

Hello. There was such a problem: the site has a form with several select and one input in which the client enters the circulation of the order. Product prices are in the excel .xlsx file. With different select, prices are different. How can I dynamically take prices from an excel file? For example, a client selects select business cards and enters the quantity 2. I need to take the price of a business card (and it also depends on the circulation) and multiply by 2. Then he wants to calculate other products. For now, just a calculation.
The manager knows only excel, but it's impossible to switch to mysql due to the large number of tables in excel and their complexity is unrealistic.
Do I need to somehow take the value from the cell I need?
Thanks for answers.

Answer 1

Convert all xls to csv, then use js to convert csv to an array and read the column you need by index ...
Or a small server script that, upon request, will return the value of the desired column from the desired file, you can find CSV and XLS readers there and no base :)