Excel in the browser

Question

JavaScript

The situation is this:

There is a table in the MySQL database (just don't swear, I know that there are better databases) with ~ 700,000 records containing information about products, including SEO fields (title, description, and something else) by 3 different languages.

There is a more/less technically savvy SEO who can even do it himself! upload the data from the database to an XLS file (in my opinion, via phpMyAdmin), edit it (including using formulas) and upload the data back to the table (using the same Excell UPDATE queries and the same pma by executing these queries on bd).

I don’t want to force a generally good person to rape himself like that, I want to increase the productivity of his work.

There was something like an idea - what if we give him the opportunity to edit the table directly in the browser? Those. make some extremely truncated analogue of Exell / Google Docs Spreadsheet. By and large, only the ability to concatenate strings and “stretch” formulas vertically is needed. Well, the Save button of course. I myself know pretty well I can only look in the direction of js.

Cross-browser compatibility, of course, is welcome, but by and large, you can force a person to sit in a particular browser

. So, oh great Habr, can you tell me, unworthy, if one of your followers has met something on the vast expanses of the Internet similar, did you try to use or write your bike? At least in which direction to dig?

Putting my hand on my karma, I swear - if anyone helps, I will write a detailed report and publish it right there.

Thank you.

Answer 1

plugindetector.com/socialcalc - but this is probably a tin at all?

Answer 2

Alternatively, you can look towards the Google Docs API and Google Spreadsheets to do this. True, there are too many lines, you need to work on some kind of selection.
And to come up with a spreadsheet editor IMHO is a utopia ...

Answer 3

I didn’t even think that the toaster was so old. people really tell me how to implement table processing in the browser
found
sudo.in/id144
and
but it was too clumsy done. tell me the best option?