How to calculate an excel table on the server using formulas from the table?

Question

API

Help. We got confused to choose the option of calculating a table from xls using internal formulas, and for it to work on the server. In addition to standard arithmetic operations, various oddities are possible there, so importing a file into some standard library and counting in it, if it does not do it perfectly, is to get a broken application in the very near future. It seems that there is an option with win32api and running Excel, but the developers with whom we are now working on the issue closer to web applications, and conscience does not allow to put into work a task that cannot be implemented by standard means in advance.
What are the solutions: (a) from the standard c#, python, php libraries, (b) using win32com (who worked with them), (c) google cloud services, office365 (who worked with their api, please answer)

Answer 1

PHPExcel will do

Answer 2

use Vbscript
VBS opens xls and runs script from it.

Answer 3

MSSQL + Excel
Excellent solution
Or, Access + MSSQL + Excel
You can create forms in Excel.
Need more information to give advice.
Excel formulas are still calculated on the client)
It needs to be separated, it won't work without third-party server software.

Answer 4

A similar task is currently under development. Only there they also asked to add macros. You have to run excel on the server, load the page and data into it, execute macros, read the data and give it to the client. There are very large restrictions on speed, tk. the excel file needs to be opened, which is 90% of the total delay time. You also need to make sure that excel can open a dialog box. At a wrong time.
However, if you have nothing but formulas, then you can try https://handsontable.com/docs/6.2.2/demo-formula-s... . It seems to me that it is quite possible to add your own formulas if you master parsing.
Not a free component, but if the network is internal, then for tests you can dig into the sources. )))