Pythonでもっと自由を

【Python×Excel】Conditional formatting (Cell Highlighting, Uppter/Lower Extraction) in openpyxl 【Part2】

This section explains how to manipulate Excel's conditional formatting in the openpyxl library. This article uses illustrations to show examples of applying the "Cell Highlighting Tool" and "Upper/Lower Rules" as custom formatting.

2022/03/26 10:41

【Python×Excel】How to set conditional formatting (Data ar, Icon set, Color scale) in openpyxl【part1】

This section explains how to manipulate Excel's conditional formatting in the openpyxl library. This article uses illustrations to show examples of the application of "data bars, icon sets, and color scales".

2022/03/19 09:32

【Python×Excel】Formatting cells (Alignment, Protection, Number format, Style definition) in “openpyxl” [Part 2]

The "openpyxl library" explains how to apply formatting (style) settings such as "alignment," "protection," and "number format" to cells. In addition, it illustrates how to combine multiple formats (custom) and register them as user-defined styles.

2022/03/14 22:02