Formatter - Unified Config - Three

Preface

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

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

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

06: Step Six

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: Get head range, set head rectangle, apply head border
• Formatting Procedure: Format head border
• Formatting Procedure: Format head colors

Macro Source

The macro source can be obtained in this repository:

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

Class Diagram

Some Code Here

TBD

07: Step Seven

Steps Overview

These are the topics for unified configuration in this section:

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

Other topics are similar to the simple configuration:

• Helper: Get data range, set data rectangle, apply data border
• Formatting Procedure: Format data border

Macro Source

The macro source can be obtained in this repository:

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

Class Diagram

Some Code Here

TBD

What is Next 🤔?

There is still additional coloring. I need time to complete the material for the rest of the article.

Thank you for visiting.