Most of my work is on excel of Microsoft. Which language should I study to support mostly for excel and my work? Thanks

Question

Language to support excel of Microsoft

Answer 1

Just to add my 2 cents, C# can deal with Excel sheets too! 😉

Reference:
https://msdn.microsoft.com/en-us/library/wss56bz7.aspx

Answer 2

https://www.sololearn.com/discuss/787912/?ref=app

Answer 3

I know someone with a similar experience to you he uses Python.

- great for calculating complex math.

- used for research.

- used for many other things.

- some say it is easy to learn.

Answer 4

I think python will be suitable as it is known for its good calculation speed. All calculations can be done smoothly with python. as @Manual suggested

Answer 5

u can do it with c# as zephyr said, i have done it with java but the best is python.

Answer 6

Yes. I agree. C# and excel go very nice together.

https://www.sololearn.com/discuss/511360/?ref=app

What do you want to do ?

Answer 7

@baptiste. If you need to stay in the excel-sheet you are bound to VBA. If you can use other coding environments, I do prefer C# as it is more typesafe and more widely used.

Answer 8

Well, the first, maybe you need not to learn any programming language to work with Excell. Because Excell constains a lot of functions and inside techniques to make a difficult calculations in it;s spreadsheet tabes. Its not a matter of programming, but your preview of Excell help or study books about Excell,
But, Excell includes too a special macro language in which you can writes a snippets of code to automatize a series of Excel Commands. The language is a VBA, that means Visual Basic for Applications. This language is not teached here in Sololearn, but it is very simple to learn it;s base. What can be more difficut is to learn the object model of Excell, for get or set data between VBA code and cells and sheets in spreadsheet and next operations - like save or print these data...

Answer 9

Isn't VBA made for the job ?

Answer 10

I agree @sneeze but as he said most of his work was in excel, I thought that a language specialized for this was better :)