Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Open, Edit and Save | Excel Automation with Python
Excel Automation with Python

Open, Edit and Save

Now that we are halfway into our project, let's practice a full pipeline with openpyxl! Here is our file "hello_world.xlsx":

Task

  1. Open the workbook called "hello_world.xlsx";
  2. Add "Test text" to the "C1" cell;
  3. Save the workbook.

Here is "hello_world_append.xlsx" after successfully completing the task:

Mark tasks as Completed

Everything was clear?

Section 1. Chapter 7
AVAILABLE TO ULTIMATE ONLY
course content

Course Content

Excel Automation with Python

Excel Automation with Python

Open, Edit and Save

Now that we are halfway into our project, let's practice a full pipeline with openpyxl! Here is our file "hello_world.xlsx":

Task

  1. Open the workbook called "hello_world.xlsx";
  2. Add "Test text" to the "C1" cell;
  3. Save the workbook.

Here is "hello_world_append.xlsx" after successfully completing the task:

Mark tasks as Completed

Everything was clear?

Section 1. Chapter 7
AVAILABLE TO ULTIMATE ONLY
some-alt