Table Format Wizard

Table Format Wizard

Users can change database objects of Excel data tables using the query list and the Connection Wizard.

The SaveToDB add-in saves database object formatting before changing and applies the saved or default formatting to a new object.
So users do not lose their formats and work.

See topics about table format elements and default table formatting below.

Table formats can be saved in a database and applied back from a database if this feature is configured.
See Configuring table formats.

The Table Format Wizard allows users to perform different tasks with the table formats.

Table Format Wizard

Save in Workbook
The button saves formats of the selected tables in the workbook.
Restore from Workbook
The button restores formats of the selected tables from the workbook.
Clear in Workbook
The button deletes formats of the selected tables in the workbook.
Save in Database
The button saves formats of the selected tables in databases.
The button is disabled if the user has no permission on the save format procedure.
Restore from Database
The button restores formats of the selected tables from databases.
The button is disabled if databases have no saved table formats.
Clear in Database
The button clears formats of the selected tables in databases.
The button is disabled if the user has no permission on the save format procedure.
Clear Table Format
The button clears cell formats and data validation in the selected tables.
The conditional formatting is not changed.
Apply Default Format
The button applies the default table formatting. See below.
Use the Clear Table Format button to clear existing formatting before the new one.
OK
The button closes the dialog box.
Cancel
The button closes the dialog box.

Table Format Elements

The SaveToDB add-in saves and restores the following formatting:

  • Cell formats
  • Conditional formatting
  • Applied filters
  • Sort order rules
  • Table totals
  • Data validation
  • Window properties
  • Formula columns

Default Table Formatting

The SaveToDB add-in applies the following rules for default formatting:

  • Auto-sizing columns (maximum width 500px);
  • Hiding the row number column;
  • Setting the width 18px for the A column if the table does not use this column and has the row number column;
  • Setting date and time formats for date and time columns;
  • Setting data validation for database tables and views if the data changes can be saved to a database;
  • Setting special conditional formatting for non-NULL columns.
This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.