Mastering openpyxl
1. Introduction
1.1 What is openpyxl?
1.2 Installation and Setup
1.3 Basic Concepts and Terminology
1.4 Example: Reading & Writing a Simple Spreadsheet
2. Workbook and Worksheet Objects
2.1 Creating Workbooks
2.2 Accessing Worksheets
2.3 Creating Worksheets
2.4 Deleting Worksheets
2.5 Renaming Worksheets
2.6 Working with Multiple Wookbooks
2.7 Workbook Properties
3. Cells and Cell Values
3.1 Accessing Cell Values
3.2 Setting Cell Values
3.3 Data Types
3.6 Dates and Times
3.7 Working with Cell Ranges
4.1 Fonts
4.2 Fill Colors
4.3 Borders
4.4 Alignment
(see:3.5 Number Formatting)
ColorScale
IconSet
DataBar
4.7 Styles and Themes
4.8 Applying Styles to Cells and Ranges
(see:3.7 Working with Cell Ranges)
5. Charts and Graphs
5.1 Creating Charts
(see:4.8 Applying Styles to Cells and Ranges)
5.2 Chart Types
1) BarChart
2) LineChart
3) PieChart
4) ScatterChart
5) AreaChart
6) RadarChart
7) DoughnutChart
8) StockChart
5.3 Customizing Charts
5.4 Adding Charts to Worksheets
6. Images and Drawings
6.1 Adding Images to Worksheets
6.2 Working with Drawing Objects
6.3 Resizing and Positioning Images
7. Working with Tables
7.1 Creating Tables
7.3 Working with Table Data
7.4 Filtering and Sorting
8. Advanced Features
8.1 Working with Pivot Tables
8.2 Data Validation
8.3 Macros and VBA
8.4 External Links
8.5 Protecting Worksheets and Workbooks
9. Error Handling and Best Practices
9.1 Common Errors and Troubleshooting
9.3 Memory Management
9.4 Large Files and Efficient Processing
9.5 Security Consideration