Configuring Table Formats

Configuring Table Formats

When users connect to databases, Excel creates data tables and applies the default formatting.

The default formatting is very simple. And users spend a lot of time formatting tables.

The SaveToDB add-in changes this.

Users can save table formats to databases using the Table Format Wizard, and other users get the same formatting when they connect to a database.

To activate this feature, just install SaveToDB Framework to your database or create own configuration objects as described below.

Use the Table Format Wizard to manage table formats.

Saved Format Properties

The SaveToDB add-in saves and restores the following format properties:

  • Cell formats
  • Conditional formatting
  • Applied auto-filters
  • Table totals
  • Data validation
  • Window properties
  • Page setup properties
  • User's formula columns
  • User's table views

Configuration Specification

The SaveToDB add-in loads and saves table formats from tables and views with the following fields:

  1. An optional primary key column like ID

* The SaveToDB add-in does not use the TABLE_SCHEMA field values with Microsoft SQL Server Compact and SQLite.

TABLE_SCHEMA and TABLE_NAME define objects.

The TABLE_EXCEL_FORMAT_XML field contains table formats as XML and its size must be greater than 32K.

Also, you can deny direct update of underlying tables and create a stored procedure to save table formats with the following parameters:

  1. Schema
  2. Name
  3. ExcelFormatXML

Accordingly, the SaveToDB add-in uses the first found procedure instead of direct updating table format tables.

SaveToDB Framework 8 has the xls.formats table to provide working with table formats.