Зміст курсу
Excel Automation with Python (project)
Excel Automation with Python (project)
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.
Завдання
- Store extracted data in a
json
file; "Product"
is at index1
;"Units"
sold is at index3
;"Manufacturing"
is at index4
.
Дякуємо за ваш відгук!
.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.
Завдання
- Store extracted data in a
json
file; "Product"
is at index1
;"Units"
sold is at index3
;"Manufacturing"
is at index4
.