Excel Automation with Python

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

Course Content

Excel Automation with Python

Excel Automation with Python

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

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