Contenido del Curso
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.
Tarea
Swipe to show code editor
- Store extracted data in a
json
file; "Product"
is at index1
;"Units"
sold is at index3
;"Manufacturing"
is at index4
.
Mark tasks as Completed
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones
¿Todo estuvo claro?
¡Gracias por tus comentarios!
Sección 1. Capítulo 6