Formatter - Unified Config - Two

Preface

Goal: Separating formatting code and configuration. Example class using unified configuration.

After basic macro, we can step in to utilize unified configuration. And see how far can the formatting go. We will transform all the formatting procedures, from simple configuration to the unified one.

Example Sheet

You can download example ODS source here:

• github.com/…/movies/data/movies.ods

And also example XLSX result here:

• github.com/…/movies/data/movies.xlsx

04: Step Four

Steps Overview

These are the topics for unified configuration in this section:

• Class: BorderFormatManager
• Formatting Procedure: Add merged titles (multiple block of columns)
• Formatting Procedure: Set merge title (refactored for one block)
• Formatting Procedure: Add merged titles post (Hook)

Other topics are similar to the simple configuration:

• Configuration: Field Metadata Configuration
• Helper: Letter to Index
• Helper: Number Formats
• Formatting Procedure: Format Columns

Macro Source

The macro source can be obtained in this repository:

• github.com/…/movies/steps-02/FormatterTabular04.py

Class Diagram

Some Code Here

TBD

05: Step Five

Steps Overview

These are the topics for unified configuration in this section:

• Formatting Procedure: Format head borders (multiple block of columns)

Other topics are similar to the simple configuration:

• Helper: Column Letter to Index
• Helper: Format Cell Rectangle
• Predefined Constant: Color Scale (GMC)
• Predefined Constant: Line Format
• Formatting Procedure: Add merged title

Macro Source

The macro source can be obtained in this repository:

• github.com/…/movies/steps-02/FormatterTabular05.py

Class Diagram

Some Code Here

TBD

What is Next 🤔?

Using design pattern, we can colorized the header. And also give border for both header and data.

Consider continue reading [ Formatter - Unified Config - Three ].