Answer the question
In order to leave comments, you need to log in
Is it possible to synchronize a webform with an excel spreadsheet?
Good afternoon.
There is a calculator (a very large calculator) in an Excel spreadsheet. A lot of data, a lot of formulas, several sheets with tables for calculations, etc. But there are not so many input data for the calculation - about 7-8.
It was necessary to overtake such a calculator into a web page so that not only the owners of the table, but also anyone from the Internet could use it.
Transferring all the data, calculation formulas from Excel somewhere to MySQL and PHP algorithms is a very long and costly process in terms of development.
Is it possible to make a simple html page with a web form where a person would enter the initial data, they would be sent to the corresponding cells in the Excel spreadsheet, and then from the resulting cell with the calculation result would be sent back to the html page.
If this is possible, please tell me where to dig?
Answer the question
In order to leave comments, you need to log in
There is a library for this, oddly enough it's called phpExcel. You take user input, swap cells, and do getCalcultaedValue() for specific cells. Formulas are processed, not sure about the current state, but used to work.
But! Better translate to php
Similarly with the Petr Vasiliev option , there is a library for JS - ExcelJS
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question