Configuring Microsoft Excel Application Features

Configuring Microsoft Excel Application Features

The SaveToDB Add-In adds many features to Microsoft Excel from-the-box.

Developers can add power features using the server-side configurations:

  • Connecting database objects, SQL codes, HTTP and text file queries using the ribbon Query List.
  • Saving data from views, stored procedures, SQL codes, and HTTP and text file queries to a database.
  • Saving data to a database using cell Change event handlers.
  • Drill-down queries to databases and web on DoubleClick events.
  • Master-detail interfaces using SelectionChange event handlers.
  • Different actions for the Excel context menu and SaveToDB Actions menu including executing procedures, macros, and Windows Shell and CMD commands.
  • Translation of objects, fields, and parameters to a business language.
  • Parameter value lists.
  • Databases to store and distribute Excel table formats of database objects.
  • Excel formulas including DDE and RTD (Real-Time Data) in views and stored procedures.

This section describes SaveToDB add-in requirements for server-side configurations.

These are requirements for signatures of configuration view fields and procedure parameters.
The SaveToDB add-in does not use the predefined object names. Database developers have full freedom of object naming and implementation.

The best way to quickly add the server-side features to a database is to install SaveToDB Framework.

You may use the SaveToDB Framework Installer wizard to install the framework in a couple of minutes.

Also, you may generate a configuration workbook using the Configuration Workbook Generator wizard and use it to customize application features directly in Microsoft Excel.

The frameworks with full source codes and examples are included in the SaveToDB SDK that can be downloaded separately at www.savetodb.com.

Configuration topics:

SaveToDB Frameworks: