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.
- Configuration poster
- Configuring Query List
- Configuring saving changes
- Configuring event handlers
- Configuring data translations
- Configuring parameter values
- Configuring table formats
- Using parameters
- Using named cells
- Using Excel formulas