What programming language to learn to access data in excel files?

Question

IT education

Good afternoon!

There is a task - to select small data packets (5-10 cells) from excel files into a txt file and enter data from an external source (txt file) into the excel file. VBA is not suitable, because it is forcibly disabled.

What programming language is better to learn in order to write such a handler program and where does the programming language have the ability to access data in excel (not csv) files?

Thank you!

Answer 1

python: https://openpyxl.readthedocs.io/en/stable/
C# (or VB Net): https://github.com/ClosedXML/ClosedXML
F#: https://fsharp.org/guides/data-science/
NodeJS: https://github.com/mgcrea/node-xlsx
In principle, for any popular language, you can find libraries for working with Excel. So take whatever suits you best.

Answer 2

Learn Python, the openpyxl library works great with them.

Answer 3

Python

Answer 4

One of my freelance tasks was working with Excel data. I made an application in C#. There is a special library (however, I forgot the name for a long time). It allows you to work with Excel data faster than standard tools.