< Automate Excel Files with Python OpenPyXL

41 casts | 4:58:09 for the total course

created by Mammoth Interactive INC

• 1. 01 Introduction to the Course
  • Automate Excel Files - OpenPyXL | Course Overview | 1.1
  • Automate Excel Files - OpenPyXL | Run OpenPyXL on the Web | 1.1
• 2. 02 Use OpenPyXL and Sheets
  • Automate Excel Files - OpenPyXL | Make a Workbook | 2.1

  • Automate Excel Files - OpenPyXL | Save a Workbook | 2.2

  • Automate Excel Files - OpenPyXL | Read a Workbook | 2.3

  • Automate Excel Files - OpenPyXL | Work with Rows and Columns | 2.4

  • Automate Excel Files - OpenPyXL | Use a Formula | 2.5

  • Automate Excel Files - OpenPyXL | Use Dates | 2.6

  • Automate Excel Files - OpenPyXL | Merge and Unmerge Cells | 2.7

  • Automate Excel Files - OpenPyXL | Fold a Range | 2.8

  • Automate Excel Files - OpenPyXL | Make a New Sheet | 2.9

  • Automate Excel Files - OpenPyXL | Copy Data to a Sheet | 2.10

  • Automate Excel Files - OpenPyXL | Remove a Sheet | 2.11

• 3. 03.01 Worksheet Tables

  • Automate Excel Files - OpenPyXL | Build a Table | 3.1

  • Automate Excel Files - OpenPyXL | Style a Table | 3.2

• 4. 03.02 Format Cells

  • Automate Excel Files - OpenPyXL | Import Dataset | 3.3

  • Automate Excel Files - OpenPyXL | Style a Cell | 3.4

  • Automate Excel Files - OpenPyXL | Make a Named Cell | 3.5

  • Automate Excel Files - OpenPyXL | Copy a Style | 3.6

• 5. 04 Build 2D Charts

  • Automate Excel Files - OpenPyXL | Make a Chart | 4.1

  • Automate Excel Files - OpenPyXL | Build LIne Charts | 4.2

  • Automate Excel Files - OpenPyXL | Build a Pie Chart | 4.3

  • Automate Excel Files - OpenPyXL | Build a Scatter Chart | 4.4

  • Automate Excel Files - OpenPyXL | Build an Area Chart | 4.5

• 6. 05 Project_ Employee Timelog

  • Automate Excel Files - OpenPyXL | Project Setup | 5.1

  • Automate Excel Files - OpenPyXL | Expand Columns to Fit Content | 5.2

  • Automate Excel Files - OpenPyXL | Add Dates | 5.3

  • Automate Excel Files - OpenPyXL | Add Days of the Week | 5.4

• 7. 06 Write to a Text File

  • Automate Excel Files - OpenPyXL | Read Speadsheet | 6.1

  • Automate Excel Files - OpenPyXL | Store Spreadsheet Data | 6.2

  • Automate Excel Files - OpenPyXL | Write to a Text File | 6.3

• 8. 07 Update a Spreadsheet

  • Automate Excel Files - OpenPyXL | Update the Spreadsheet | 7.2

  • Automate Excel Files - OpenPyXL | Set Up Update Information | 7.1

• 9. 08 More Chart Types

  • Automate Excel Files - OpenPyXL | Build a Stock Chart | 8.1

  • Automate Excel Files - OpenPyXL | Build a Doughnut Chart | 8.2

  • Automate Excel Files - OpenPyXL | Build a Bubble Chart | 8.3

• 10. 09 Web Scraping

  • Automate Excel Files - OpenPyXL | Import Web Driver | 9.1

  • Automate Excel Files - OpenPyXL | Scrape a Web Page | 9.2

  • Automate Excel Files - OpenPyXL | Parse Page Data | 9.3

  • Automate Excel Files - OpenPyXL | Put Data into Excel Sheet | 9.4

  • Automate Excel Files - OpenPyXL | Clean Data | 9.5