xls.formats
The xls.formats module contains table formats.
When a user connects to an object for the first time, SaveToDB products load the corresponding table formats.
The SaveToDB add-in also allows you to load and save table formats at any time using the following ribbon controls:
- Save Table Format
- Reload Table Format
- Table Format Wizard
The table structure is as follows:
| ID | TABLE_SCHEMA | TABLE_NAME | TABLE_EXCEL_FORMAT_XML | APP |
|---|---|---|---|---|
| <schema> | <object name> | <XML format> | <app> |
The APP field, introduced in SaveToDB Framework 10, can have the following values:
- NULL
- dbedit
- dbgate
- odatadb
The SaveToDB add-in supports saving table formats, which can be stored directly in tables or via stored procedures.
Stored procedures must include the following parameters: schema, name, excelFormatXML, and app.
The excelFormatXML parameter can accept an XML format or NULL (to remove the format).
You can utilize predefined procedures from the SaveToDB Framework Extension.
To load and save formats, the add-in selects the most appropriate objects.
You can specify load and save format objects using the LoadFormat and SaveFormat event handlers in the xls.handlers table.
For additional information, refer to: