Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
course content

Course Content

Excel: the Power of Openpyxl

iter_rows()iter_rows()

.iter_rows() is a method provided by the openpyxl library in Python that allows you to iterate over a range of cells in a worksheet. The iter_rows() method takes parameters specifying the starting and ending cells of the range and returns a generator that yields each row as a tuple of cell objects.

Iterating over rows in a worksheet is useful when processing or analyzing data in a specific range or subset of cells. For example, you may need to calculate the average value of a column or search for specific values or patterns in a set of cells.

Task

  1. Store extracted data in a json file;
  2. "Product" is at index 1;
  3. "Units" sold is at index 3;
  4. "Manufacturing" is at index 4.

Mark tasks as Completed

Everything was clear?

Section 1. Chapter 6
AVAILABLE TO ULTIMATE ONLY
some-alt