Use Excel file on my website server as an inventory file?

Question

I hope this question makes enough sense.

I have an Excel sheet with about 150 stock items. These stock items have columns such as "Batch Number - Expiry Date - Quantity"; as an example.

I'm using Joomla for our small company website. Is there ANY way I can implement this Excel file and create a point-of-sale system? As in, use this Excel sheet as a live stock which can display in the site? There must be some scripts or something to that effect.

I can use Excel online and sharepoint, but that only shows the stock, you can't place orders and such. Is there any other good inventory management software?

Thanks

Answer 1

I think you should parse that excel file and insert it to joomla database, then you can manage that stock data online, and data will be updated in real time for

Answer 2

It seems you should consider what you are really asking as this looks a lot like an XY problem.

You are asking how to interact with an Excel spreadsheet from PHP to treat that spreadsheet as a database. Is there a reason why you wouldn't use an actual database?

Unless there is a particular reason why a SQL database (or NoSQL) doesn't suit your needs it would serve you to read more about how to use them with PHP before trying to repurpose a round peg (Excel spreadsheet) to fit into a square hole (Database)