What is the best way to develop applications for processing Excel files?

Question

JavaScript

Hello,
I am not a programmer and do not work as a programmer. But I'm starting to learn programming languages. In particular, I know a little C / C ++ and I'm starting to learn JavaScript.
At work, I was asked to develop a program (for Windows) that would accept several Excel files, in which information about objects and data on them for a month, process them and form a pivot table (in the program itself, and then import into Excel).
Need help choosing development technologies.
For the database, I'm thinking of using MySql or MongoDB.
And I would like to write the application itself using NW.js. It would help me in learning web technologies. But I don't know how difficult it is to work with Excel files in JS.
Maybe take another programming language? Or am I thinking in the wrong direction at all? :)
I would be very grateful for your advice.
PS I apologize for those. illiteracy.

Answer 1

if other languages ​​- then mb C# or Java

Answer 2

It is better to work with Excel from JS through ActiveX.
Something like this:
var excel = new ActiveXObject("Excel.Application");
var ws = excel.Workbooks.Open(file_name).Worksheets;
well, then sort through sheet Cells and add them to the base.
But only if as a JS training, otherwise I would rather write a VB script and that's it.

Answer 3

Save to Excel in CSV format. CSV files are directly loaded into the MySQL database (viaLOAD DATA INFILE ).

Answer 4

Python + pandas to help you