Extending Excel Context Menu

Extending Excel Context Menu

The SaveToDB add-in allows extending the Microsoft Excel context menu.

There are three available submenus:

  • Actions
  • Open URL
  • Table Views

Actions Context Menu

The Actions menu allows executing various tasks:

  • Executing stored procedures and SQL queries
  • Executing HTTP requests and opening URLs
  • Executing VBA macros

Users can customize the menu using the context menu elements of the Reports tab configuration.

Developers can customize the menu using the event handlers with the ContextMenu event type. See Developer Guide.

Below is a sample of the context menu:

Example of the SaveToDB Context Menu

Open URL Context Menu

The SaveToDB add-in automatically adds the Open URL submenu when the active cell or any cell of the active table row has a URL.

You can turn on or off this feature using the Options dialog box.

Table Views Context Menu

The SaveToDB add-in adds the Table Views submenu automatically when the active table has saved table views.

For example:

Example of the Table Views Context Menu

You can turn on or off this feature using the Options dialog box.