This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	Python (34 exercises)
Topic ==>	CSV and Excel (2 exercises)
Level ==>	Average difficulty
Subject ==>	Python training

Open an Excel workbook and read down a list of plants finding the ones not in stock

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Before you can do this exercise, you'll need to download and unzip this file.

The above folder contains a workbook listing plants, some of which are not in stock:

The plants not in stock are shown with the value No in column H (as helpfully highllighted above).

Create a program called Night-scented unstocked.py to:

Import the openpyxl module.
Open the workbook containing the list of plants.
Get a reference to the first sheet (called Sheet1).
Get a reference to cell A2.
Keep going down until your program hits a blank cell (ie one whose value is None), checking the value of the cell offset 0 rows down and 7 columns to the right of the current one for each (if this is No your macro should print out this plant's name).

Make sure you save your program before you try running it, as if you create an infinite loop you may end up having to close down Visual Studio Code!

A typical output from your macro when it's finished might be something like this: