Microsoft Office performs not “comprise” any sort of programs foreign languages. Microsoft Office apps are actually end-user adapted and also “comprise” Office records (Excel books, PowerPoint presentations, Get access to data banks, Word files, etc). The existing documents layout is Office Open XML, which is actually a ZIP bundle consisting of XML documents that, as a whole entire, indicate the paper.
As Maurice claims, they have a programs language alike, referred to as VBA, which is actually utilized to expand as well as tailor each request’s capacities.
As a previous software program app innovation developer for Microsoft Office 2011 for the Mac computer, I can easily tell you that it was largely ported coming from the Microsoft window variation in Visual C++ to C++ in Apple’s XCode advancement setting. In 2011, nonetheless, the mass of Microsoft office (i.e. Excel, PowerPoint, as well as Word) was actually created in C++ and a few of the code dated back to nearly twenty years prior to my existing.
In addition, each exposes a shows interface of the type COM-OLE through which they can be automated by other languages that support utilizing COM-OLE, consisting of VBA running in other applications. Examples of such languages: C++, C#, VB.NET, timeless VB, Delphi, vb scripting …
the Office applications, themselves, are mainly written in a C-language (which depends upon how old they are).
Checking out a stand out file through POI is rather uncomplicated, although if it; s a large stand out file you should utilize the eventmodel api. I believe the only things that don’t work are macros, a few stand out functions and sharepoint integeration.
C#, probably has the capability to call Excel natively, will probably have better assistance for all the features Once again, wear; t take my word for it. It’s been 10 years considering that I write something to open an Excel file in C++, and at that time you got a COM object from the system and utilized it to retreive the data. The Excel program installed on the system served as the COM server, when you requested the COM interface, WIndows would begin Excel behind the scenes to check out the excel file. This implied that you had full assistance of Excel set up on the system you were making the call. Also, it implied that you had to have the right version of Excel installed. I don’t know if they changed things now. I am pretty positive they will have Sharepoint integration in C#. Definetly look at whether C# has much better functions.
IMO, I would change from Java to C# just if
1. POI doesn’ t support the features that you need. This is incredibly not likely. It’s unlikely that you will be tied to sharepoint if you are currently a Java store. And you probably will have the ability to convert all Excel macros to Java code
2. you wanted to find out C#, and present the innovation to the business. A module that requires great combination with Microsoft Office appears like a great place to check the waters with Microsoft development stacks.
I have actually utilized C# to develop Excel does formerly. It enables you to read write excel files and produce charts etc.