All geek questions in one place

Create an add-in and UDF for all versions of Excel

One data provider wants to develop an Excel add-in, these are the following requirements:

1) it can be installed on the desktop. It adds one menu and buttons to the ribbon, and also provides some specific functions (for receiving real-time data, such as the Bloomberg function).

2) the add-in should work in Excel 2007, 2010, 2013 and 2016.

The question is which technology should be used to create this add-in. Here are some of my thoughts:

1) JavaScript API for Excel is not suitable, because it does not work for Excel 2007, 2010.

2) VSTO. Does anyone know if VSTO add-ins work for Excel 2013 and 2016? ; Is it possible to create one VSTO add-in that works for all Excel 2007, 2010, 2013 and 2016?

3) C API for Excel. It seems that the C API for Excel is used to build XLL. Does anyone know if the C API for Excel can create menus and buttons?

+4
source share
1 answer

Here are a few points:

  • JavaScript API, -, , , , , . , 2013 . .

  • VSTO, , , , MDI/SDI Excel 2013 . ( idmso, ..), VSTO 2007 2016 . VSTO 2016 , - 2010 ( 4.0 Runtime). , .

  • ( ) Excel C Api ( xlfAddMenu xlfAddToolbar), , IRIBbonExtensibility COM Interface. , rubbon - COM ( VSTO). API Excel C 2007, . SDK 2010 Excel C API SDK 2013 - ), GENERIC.C . xlAutoOpen. , .

: 1) VSTO 2) API Excel C VSTO, . (VSTO), .

EDIT:

, UDF. UDF Excel: VBA, COM API Excel C. UDF - , , API EXCEL C, , "" API #, . Excel DNA.

2:

VSTO, ,

+1

Source: https://habr.com/ru/post/1660135/

More articles:


All Articles