Kursinnehåll
Excel Automation with Python (project)
Excel Automation with Python (project)
 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.
Uppgift
Swipe to start coding
- Store extracted data in a jsonfile;
- "Product"is at index- 1;
- "Units"sold is at index- 3;
- "Manufacturing"is at index- 4.
Lösning
Mark tasks as Completed
Var allt tydligt?
Tack för dina kommentarer!
Avsnitt 1. Kapitel 6
AVAILABLE TO ULTIMATE ONLY