course content

Course Content

Excel Mastery with Python: Unleashing the Power of Openpyxl

1. Openpyxl

IntroductionCreate WorkbookSaveLoad WorkbookCell Valuesiter_rows()Open, Edit and SaveFiltersFormulasOpenpyxl and PandasCharts

Excel Mastery with Python: Unleashing the Power of Openpyxl

FiltersFilters

auto_filter() is a method provided by the openpyxl library in Python that allows you to create a filter on a range of cells in a worksheet. The auto_filter() method takes parameters specifying the starting and ending cells of the range and the criteria for the filter, such as a range of values or a text string.

Task

  1. Define a filter from cell "A1" to "0100";
  2. Save the workbook.

Everything was clear?

Section 1. Chapter 8

Start learning today and achieve
coding mastery

  • Master Python, SQL, JavaScript & more.
  • Learn with Step-by-Step Lessons.
  • Get Ready for Real-World Projects.
  • Earn a Certificate Upon Completion.