How to make Ribbon menu by Excel
First, create a VSTO program, as shown in the figure of creating an Excel add-in in VS:
Then, add an item and add a ribbon menu:
Before creating a menu, we need to know which modules our plug-in has. Here, in order to demonstrate how to create the menu and the following function points, our plug-in intends to make four function points. The first is the financial module, which includes obtaining real-time or historical market data from some open financial APIs such as Sina Finance API and Yahoo API. Map module, including map display, address retrieval, thematic mapping, etc. The weather module is used for acquiring weather and weather protection tables; System modules, including login, help, about modules, etc. After determining the function points, you can start to create the menu.
after adding the Ribbon menu, you can open the ToolBox and start the design, as shown below. Here are the functions and design points of each menu item.