Python Excel – Styling Your Worksheets

Part 6 in Working with Excel focuses on styling.  Impress your customers by styling the Worksheet to match their brand by: adding in their unique logo, using their color scheme, using their preferred font style, formatting the Worksheet using their preferred report style. Taking the time to do this makes you stand above the crowd. … Read more

Python Excel – Sum, Average, Max, and Date Formulas

Part 5 in the Working with Excel series focuses on formulas.   Background After completing Part 4 of this series, you should be comfortable using Python and openpyxl to: add worksheets rename worksheets reorder worksheets delete Worksheets Remember to add the Required Starter Code (lines [1-4]) to the top of each code snippet. This snippet … Read more

Python Excel – Basic Worksheet Operations

Part 4 in the Working with Excel series focuses on Worksheet(s) manipulation.   Background After completing Part 3 of this series, you should be comfortable using Python and openpyxl to: append row(s), modify data, insert column(s), delete row(s) and column(s) Remember to add the Required Starter Code (lines [1-4]) to the top of each code … Read more