Course Content
Excel Automation with Python
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
- Store extracted data in a
jsonfile; "Product"is at index1;"Units"sold is at index3;"Manufacturing"is at index4.
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
.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
- Store extracted data in a
jsonfile; "Product"is at index1;"Units"sold is at index3;"Manufacturing"is at index4.
Switch to desktop for real-world practiceContinue from where you are using one of the options below