Articles by George Mount

How to format a column as percentage in Excel using openpyxl

May 22, 2023 | George Mount

Excel’s popularity is attributed to its user-friendly data formatting and presentation features. Although Python offers distinct advantages for Excel, its raw data output is often unsuitable for business purposes. The following notebook demonstrates how to create a calculated percentage column in pandas and format the results in an Excel ... [...Read more...]

How to automatically adjust Excel column widths in openpyxl

May 22, 2023 | George Mount

Excel’s popularity stems from its user-friendly data formatting and presentation capabilities. Take, for example, the nuisance of narrow columns. Resolving this issue in Excel is as simple as selecting the affected columns and double-clicking on any one of them: Python does present unique strengths to Excel, but visual formatting ...
[...Read more...]

How to visualize data in Excel with openpyxl

May 16, 2023 | George Mount

In a previous post, I discussed Python’s role in the modern Excel stack. Another advantage of using Python with Excel is the wealth of data visualization options available. When working with Excel data visualizations using Python, you have two options: automating the production of an Excel chart entirely from ... [...Read more...]
1 2 3 4 5 10