Today we learn how to get well-formatted reports in Excel from a database.

Let's open our well-known example of payments:

https://www.savetodb.com/downloads/example_of_payments.xlsx (23 KB)

Open the query list and select CashFlow Year:

You will get the report like this:

You may see that the report has hidden columns and conditional formatting.

The add-in loads such formats from a database when you connect for the first time.

You may use Table Format Wizard to manage table formats in a workbook and a database.

For example, you may format a report, save its format to a database, and your colleagues will get it.

You may reload table formats from a database when your colleagues have saved them to a database.

This feature requires SaveToDB Framework installed. We will discuss it in the next letter.

Best regards,

Sergey Vaselenko
CEO | Gartle Technology Corporation

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.