Course Content

Excel: the Power of Openpyxl

Introduction Create Workbook Save Load Workbook Cell Values iter_rows()Open, Edit and Save Filters Formulas Openpyxl and Pandas Charts

Excel: the Power of Openpyxl

Cell Values

Now that we have imported our Excel file in our environment, let's print out some cells values. We work with sample_data.xlsx file. Here is the file content:

Task

Select the current active sheet;
Print the value of the "A1" cell (using the .value attribute);
Select the cell corresponing to the 6-th row and to the 10-th column.

Mark tasks as Completed

Everything was clear?

Section 1. Chapter 5

AVAILABLE TO ULTIMATE ONLY

some-alt