Web spreadsheet that can access the database

Question

I am a little new to web development and wanted to get an idea of ​​how to approach my project.

We have big mysql with a fairly large dataset that we want people to play with. Is there a way to have some kind of web spreadsheet that, in addition to regular spreadsheet calculations, queries the database and displays the contents? We have niche static information about the companies that we are researching, ideally, the user would come to the site and have access to our data, adding their own logic (mathematical operators) to make it more relevant for them.

We do not want to create api to connect to their desktops (for now) and we want to do this completely through the Internet.

Any help on the approach or tools that you will use would be greatly appreciated.

Thanks in advance

Edit: I found a nice tool for drupal "Sheetnode" that uses phpexcel .... I will study it, I'm not quite sure that it allows adding mysql queries to cells.

Answer 1

YUI datatable . YUI . , . , . Drupal, . _hook Drupal RESTful JavaScript.

Answer 2

, phpexcel (phpexcel.codeplex.com/) , , drupal.

Answer 3

If you are familiar with Java, the most appropriate choice is probably https://vaadin.com/spreadsheet and using the open-source framework Vaadin (Disclaimer: I work on the company for the tool).

But anyway, with this it is as simple as:

Spreadsheet s = new Spreadsheet(
    new File("/path/to/some/xls/file/on/server.xlsx"));
layout.addComponent(s);

to add an excel file to your web browser.