<map version="freeplane 1.12.1">
<!--To view this file, download free mind mapping software Freeplane from https://www.freeplane.org -->
<node TEXT="Mastering openpyxl" LOCALIZED_STYLE_REF="AutomaticLayout.level.root" FOLDED="false" ID="ID_1090958577" CREATED="1409300609620" MODIFIED="1766817575719"><hook NAME="MapStyle" background="#f5f5dcff" zoom="0.82644624">
    <properties show_icon_for_attributes="true" edgeColorConfiguration="#808080ff,#ff0000ff,#0000ffff,#00ff00ff,#ff00ffff,#00ffffff,#7c0000ff,#00007cff,#007c00ff,#7c007cff,#007c7cff,#7c7c00ff" show_tags="UNDER_NODES" show_note_icons="true" associatedTemplateLocation="template:/light_sepia_template.mm" fit_to_viewport="false" show_icons="BESIDE_NODES"/>
    <tags category_separator="::"/>

<map_styles>
<stylenode LOCALIZED_TEXT="styles.root_node" STYLE="oval" UNIFORM_SHAPE="true" VGAP_QUANTITY="24 pt">
<font SIZE="24"/>
<stylenode LOCALIZED_TEXT="styles.predefined" POSITION="bottom_or_right" STYLE="bubble">
<stylenode LOCALIZED_TEXT="default" ID="ID_1558627382" ICON_SIZE="12 pt" FORMAT_AS_HYPERLINK="false" COLOR="#2c2b29" BACKGROUND_COLOR="#eedfcc" STYLE="bubble" SHAPE_HORIZONTAL_MARGIN="8 pt" SHAPE_VERTICAL_MARGIN="5 pt" BORDER_WIDTH_LIKE_EDGE="false" BORDER_WIDTH="1.9 px" BORDER_COLOR_LIKE_EDGE="true" BORDER_COLOR="#f0f0f0" BORDER_DASH_LIKE_EDGE="true" BORDER_DASH="SOLID" VGAP_QUANTITY="3 pt">
<arrowlink SHAPE="CUBIC_CURVE" COLOR="#000000" WIDTH="2" TRANSPARENCY="200" DASH="" FONT_SIZE="9" FONT_FAMILY="SansSerif" DESTINATION="ID_1558627382" STARTINCLINATION="81.75 pt;-9 pt;" ENDINCLINATION="81.75 pt;19.5 pt;" STARTARROW="NONE" ENDARROW="DEFAULT"/>
<font NAME="SansSerif" SIZE="9" BOLD="false" STRIKETHROUGH="false" ITALIC="false"/>
<edge STYLE="bezier" COLOR="#2e3440" WIDTH="3" DASH="SOLID"/>
<richcontent TYPE="DETAILS" CONTENT-TYPE="plain/auto"/>
<richcontent TYPE="NOTE" CONTENT-TYPE="plain/auto"/>
</stylenode>
<stylenode LOCALIZED_TEXT="defaultstyle.details" COLOR="#ffffff" BACKGROUND_COLOR="#2e3440">
<font SIZE="10"/>
</stylenode>
<stylenode LOCALIZED_TEXT="defaultstyle.tags">
<font SIZE="10"/>
</stylenode>
<stylenode LOCALIZED_TEXT="defaultstyle.attributes">
<font SIZE="10"/>
</stylenode>
<stylenode LOCALIZED_TEXT="defaultstyle.note" COLOR="#000000" BACKGROUND_COLOR="#f6f9a1" TEXT_ALIGN="LEFT">
<icon BUILTIN="clock2"/>
<font SIZE="10" ITALIC="true"/>
</stylenode>
<stylenode LOCALIZED_TEXT="defaultstyle.floating">
<edge STYLE="hide_edge"/>
<cloud COLOR="#f0f0f0" SHAPE="ROUND_RECT"/>
</stylenode>
<stylenode LOCALIZED_TEXT="defaultstyle.selection" COLOR="#2c2b29" BACKGROUND_COLOR="#ffffff" BORDER_COLOR_LIKE_EDGE="false" BORDER_COLOR="#bf616a"/>
</stylenode>
<stylenode LOCALIZED_TEXT="styles.user-defined" POSITION="bottom_or_right" STYLE="bubble">
<stylenode LOCALIZED_TEXT="styles.important" ID="ID_411331447" COLOR="#ffffff" BACKGROUND_COLOR="#bf616a" BORDER_COLOR="#bf616a">
<icon BUILTIN="yes"/>
<arrowlink COLOR="#bf616a" TRANSPARENCY="255" DESTINATION="ID_411331447"/>
<font NAME="Ubuntu" SIZE="12" BOLD="true"/>
<edge COLOR="#bf616a"/>
</stylenode>
<stylenode LOCALIZED_TEXT="styles.flower" COLOR="#ffffff" BACKGROUND_COLOR="#255aba" STYLE="oval" TEXT_ALIGN="CENTER" BORDER_WIDTH_LIKE_EDGE="false" BORDER_WIDTH="22 pt" BORDER_COLOR_LIKE_EDGE="false" BORDER_COLOR="#f9d71c" BORDER_DASH_LIKE_EDGE="false" BORDER_DASH="CLOSE_DOTS" MAX_WIDTH="6 cm" MIN_WIDTH="3 cm"/>
</stylenode>
<stylenode LOCALIZED_TEXT="styles.AutomaticLayout" POSITION="bottom_or_right" STYLE="bubble">
<stylenode LOCALIZED_TEXT="AutomaticLayout.level.root" COLOR="#ffffff" BACKGROUND_COLOR="#2c2b29" STYLE="bubble" SHAPE_HORIZONTAL_MARGIN="10 pt" SHAPE_VERTICAL_MARGIN="10 pt" BORDER_COLOR_LIKE_EDGE="false" BORDER_COLOR="#2c2b29" BORDER_DASH_LIKE_EDGE="true">
<font SIZE="18"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,1" STYLE="bubble" SHAPE_HORIZONTAL_MARGIN="8 pt" SHAPE_VERTICAL_MARGIN="5 pt" BORDER_COLOR="#2c2b29">
<font SIZE="16"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,2" STYLE="bubble" SHAPE_HORIZONTAL_MARGIN="8 pt" SHAPE_VERTICAL_MARGIN="5 pt" BORDER_COLOR_LIKE_EDGE="true" BORDER_COLOR="#f0f0f0">
<font SIZE="14"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,3" STYLE="bubble" SHAPE_HORIZONTAL_MARGIN="8 pt" SHAPE_VERTICAL_MARGIN="5 pt" BORDER_COLOR_LIKE_EDGE="true" BORDER_COLOR="#f0f0f0">
<font SIZE="12"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,4" BACKGROUND_COLOR="#eedfcc" BORDER_COLOR_LIKE_EDGE="true" BORDER_COLOR="#f0f0f0">
<font SIZE="11"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,5" BORDER_COLOR_LIKE_EDGE="true" BORDER_COLOR="#f0f0f0">
<font SIZE="11"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,6" BORDER_COLOR_LIKE_EDGE="true" BORDER_COLOR="#f0f0f0">
<font SIZE="10"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,7" BORDER_COLOR="#f0f0f0">
<font SIZE="10"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,8" BORDER_COLOR="#f0f0f0">
<font SIZE="10"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,9" BORDER_COLOR="#f0f0f0">
<font SIZE="10"/>
</stylenode>
<stylenode LOCALIZED_TEXT="AutomaticLayout.level,10" BORDER_COLOR="#f0f0f0"/>
</stylenode>
</stylenode>
</map_styles>
</hook>
<hook NAME="accessories/plugins/AutomaticLayout.properties" VALUE="ALL"/>
<font BOLD="true"/>
<node TEXT="1. Introduction" FOLDED="true" POSITION="bottom_or_right" ID="ID_1381673064" CREATED="1766817605541" MODIFIED="1766817617918">
<node TEXT="1.1 What is openpyxl?" ID="ID_1015109321" CREATED="1766817617923" MODIFIED="1766817623552"/>
<node TEXT="1.2 Installation and Setup" ID="ID_1853887514" CREATED="1766817623733" MODIFIED="1766817629345"/>
<node TEXT="1.3 Basic Concepts and Terminology" ID="ID_138159166" CREATED="1766817629510" MODIFIED="1766817640920"/>
<node TEXT="1.4 Example: Reading &amp; Writing a Simple Spreadsheet" ID="ID_1038187386" CREATED="1766817641077" MODIFIED="1766817654839"/>
</node>
<node TEXT="2. Workbook and Worksheet Objects" FOLDED="true" POSITION="bottom_or_right" ID="ID_1498095234" CREATED="1766817656021" MODIFIED="1766817664425">
<node TEXT="2.1 Creating Workbooks" ID="ID_878225933" CREATED="1766842961269" MODIFIED="1766842970082"/>
<node TEXT="2.2 Accessing Worksheets" ID="ID_847946850" CREATED="1766842970277" MODIFIED="1766842978450"/>
<node TEXT="2.3 Creating Worksheets" ID="ID_317758166" CREATED="1766842978765" MODIFIED="1766842983961"/>
<node TEXT="2.4 Deleting Worksheets" ID="ID_1718539512" CREATED="1766842984179" MODIFIED="1766842989055"/>
<node TEXT="2.5 Renaming Worksheets" ID="ID_318527834" CREATED="1766842989238" MODIFIED="1766842994911"/>
<node TEXT="2.6 Working with Multiple Wookbooks" ID="ID_838517300" CREATED="1766842995093" MODIFIED="1766843010599"/>
<node TEXT="2.7 Workbook Properties" ID="ID_116121184" CREATED="1767099093250" MODIFIED="1767099100108"/>
</node>
<node TEXT="3. Cells and Cell Values" FOLDED="true" POSITION="bottom_or_right" ID="ID_928661939" CREATED="1766817664557" MODIFIED="1767189979752" VGAP_QUANTITY="3 pt">
<node TEXT="3.1 Accessing Cell Values" ID="ID_1281735644" CREATED="1766843051076" MODIFIED="1766843058527"/>
<node TEXT="3.2 Setting Cell Values" ID="ID_773149241" CREATED="1766843058708" MODIFIED="1766843063398"/>
<node TEXT="3.3 Data Types" ID="ID_139154431" CREATED="1766843063595" MODIFIED="1766843073840"/>
<node TEXT="3.4 Formulas and Calculations" ID="ID_1553302130" CREATED="1766843074012" MODIFIED="1767189979751"/>
<node TEXT="3.5 Number Formatting" ID="ID_1678773971" CREATED="1766843081187" MODIFIED="1766843086236"/>
<node TEXT="3.6 Dates and Times" ID="ID_503538469" CREATED="1766843086428" MODIFIED="1766843093909"/>
<node TEXT="3.7 Working with Cell Ranges" ID="ID_297430130" CREATED="1766843094073" MODIFIED="1767189979753"/>
</node>
<node TEXT="4. Styles and Formatting" FOLDED="true" POSITION="bottom_or_right" ID="ID_142973714" CREATED="1766817670901" MODIFIED="1767189979755" VGAP_QUANTITY="3 pt">
<node TEXT="4.1 Fonts" POSITION="bottom_or_right" ID="ID_1876183140" CREATED="1766843111748" MODIFIED="1767161505231"/>
<node TEXT="4.2 Fill Colors" POSITION="bottom_or_right" ID="ID_323528573" CREATED="1766843115740" MODIFIED="1767161521499"/>
<node TEXT="4.3 Borders" POSITION="bottom_or_right" ID="ID_169744314" CREATED="1766843124739" MODIFIED="1767161516617"/>
<node TEXT="4.4 Alignment" POSITION="bottom_or_right" ID="ID_1829779086" CREATED="1766843131562" MODIFIED="1767161514032"/>
<node TEXT="4.5 Number Formats" ID="ID_180675859" CREATED="1766843170520" MODIFIED="1767162274295">
<arrowlink DESTINATION="ID_1678773971"/>
</node>
<node TEXT="4.6 Conditional Formatting" FOLDED="true" ID="ID_285696711" CREATED="1766843176535" MODIFIED="1767161527843" LINK="https://openpyxl.pages.heptapod.net/openpyxl/formatting.html">
<node TEXT="4.6.1 Built-in formats" ID="ID_1886296178" CREATED="1767062013048" MODIFIED="1767184341902">
<node TEXT="ColorScale" ID="ID_1007574450" CREATED="1767062029487" MODIFIED="1767062032841"/>
<node TEXT="IconSet" ID="ID_1027743473" CREATED="1767062033415" MODIFIED="1767062036569"/>
<node TEXT="DataBar" ID="ID_1764799093" CREATED="1767062036742" MODIFIED="1767062038332"/>
</node>
<node TEXT="4.6.2 Standard conditional formats" ID="ID_1188944666" CREATED="1767062039142" MODIFIED="1767162670321"/>
<node TEXT="4.6.3 Formatting Entire Rows" ID="ID_1399287069" CREATED="1767062045302" MODIFIED="1767162746873"/>
</node>
<node TEXT="4.7 Styles and Themes" ID="ID_1918883245" CREATED="1766843224454" MODIFIED="1767161531530"/>
<node TEXT="4.8 Applying Styles to Cells and Ranges" ID="ID_1765697633" CREATED="1766843235038" MODIFIED="1767189979753">
<arrowlink DESTINATION="ID_297430130"/>
</node>
</node>
<node TEXT="5. Charts and Graphs" FOLDED="true" POSITION="bottom_or_right" ID="ID_1021077158" CREATED="1766817676932" MODIFIED="1766817682255">
<node TEXT="5.1 Creating Charts" ID="ID_1752474475" CREATED="1766843250094" MODIFIED="1767164964614">
<arrowlink DESTINATION="ID_1765697633"/>
</node>
<node TEXT="5.2 Chart Types" ID="ID_1549891957" CREATED="1766843260061" MODIFIED="1766843263896">
<node TEXT="1) BarChart" ID="ID_1664511420" CREATED="1767193563693" MODIFIED="1767193587100"/>
<node TEXT="2) LineChart" ID="ID_1921041964" CREATED="1767193587739" MODIFIED="1767193591300"/>
<node TEXT="3) PieChart" ID="ID_1847134928" CREATED="1767193591466" MODIFIED="1767193596317"/>
<node TEXT="4) ScatterChart" ID="ID_377987823" CREATED="1767193596492" MODIFIED="1767193603636"/>
<node TEXT="5) AreaChart" ID="ID_393993951" CREATED="1767193603867" MODIFIED="1767193608628"/>
<node TEXT="6) RadarChart" ID="ID_139915953" CREATED="1767193608795" MODIFIED="1767193612956"/>
<node TEXT="7) DoughnutChart" ID="ID_1441970922" CREATED="1767193613122" MODIFIED="1767193620484"/>
<node TEXT="8) StockChart" ID="ID_1218082025" CREATED="1767193620659" MODIFIED="1767193625900"/>
</node>
<node TEXT="5.3 Customizing Charts" ID="ID_1730268362" CREATED="1766843264061" MODIFIED="1766843270304"/>
<node TEXT="5.4 Adding Charts to Worksheets" ID="ID_1613889273" CREATED="1766843300949" MODIFIED="1766843308935"/>
</node>
<node TEXT="6. Images and Drawings" FOLDED="true" POSITION="bottom_or_right" ID="ID_1186576826" CREATED="1766817682405" MODIFIED="1766817688397">
<node TEXT="6.1 Adding Images to Worksheets" ID="ID_1906133330" CREATED="1766843312148" MODIFIED="1766843318655"/>
<node TEXT="6.2 Working with Drawing Objects" ID="ID_1471055104" CREATED="1766843319780" MODIFIED="1766843326378"/>
<node TEXT="6.3 Resizing and Positioning Images" ID="ID_1107743282" CREATED="1766843327340" MODIFIED="1766843334784"/>
<node TEXT="6.4 Image Formats" ID="ID_28147833" CREATED="1766843338356" MODIFIED="1766843342774"/>
</node>
<node TEXT="7. Working with Tables" FOLDED="true" POSITION="bottom_or_right" ID="ID_1309893239" CREATED="1766817688581" MODIFIED="1766817693679">
<node TEXT="7.1 Creating Tables" ID="ID_1005418389" CREATED="1766843345563" MODIFIED="1766843350677"/>
<node TEXT="7.2 Formatting Tables" ID="ID_1956944935" CREATED="1766843351987" MODIFIED="1766843356782"/>
<node TEXT="7.3 Working with Table Data" ID="ID_1954870920" CREATED="1766843361307" MODIFIED="1766843367624"/>
<node TEXT="7.4 Filtering and Sorting" ID="ID_1967396996" CREATED="1766843368883" MODIFIED="1766843374246"/>
</node>
<node TEXT="8. Advanced Features" POSITION="bottom_or_right" ID="ID_265495768" CREATED="1766817693821" MODIFIED="1766817700809">
<node TEXT="8.1 Working with Pivot Tables" ID="ID_1432754899" CREATED="1766843377075" MODIFIED="1766843385254"/>
<node TEXT="8.2 Data Validation" ID="ID_1857194258" CREATED="1766843422058" MODIFIED="1766843427489"/>
<node TEXT="8.3 Macros and VBA" ID="ID_275957856" CREATED="1766843449834" MODIFIED="1766843460068"/>
<node TEXT="8.4 External Links" ID="ID_516456642" CREATED="1766843474457" MODIFIED="1766843480355"/>
<node TEXT="8.5 Protecting Worksheets and Workbooks" ID="ID_123327826" CREATED="1766843498937" MODIFIED="1766843508291"/>
</node>
<node TEXT="9. Error Handling and Best Practices" FOLDED="true" POSITION="bottom_or_right" ID="ID_1334834984" CREATED="1766817700956" MODIFIED="1766817715662">
<node TEXT="9.1 Common Errors and Troubleshooting" ID="ID_76328088" CREATED="1766843516032" MODIFIED="1766843528322"/>
<node TEXT="9.2 Performance Optimization" ID="ID_972972413" CREATED="1766843531282" MODIFIED="1766843537890"/>
<node TEXT="9.3 Memory Management" ID="ID_1608162558" CREATED="1766843538040" MODIFIED="1766843546050"/>
<node TEXT="9.4 Large Files and Efficient Processing" ID="ID_449022239" CREATED="1766843546215" MODIFIED="1766843558122"/>
<node TEXT="9.5 Security Consideration" ID="ID_1414474048" CREATED="1766843561247" MODIFIED="1766843566883"/>
</node>
</node>
</map>
