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 (project)
Excel Automation with Python (project)
course content

Course Content

Excel Automation with Python (project)

Excel Automation with Python (project)

IntroductionCreate WorkbookSaveLoad WorkbookCell Valuesiter_rows()Open, Edit and SaveFiltersFormulasOpenpyxl and PandasCharts

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.

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
Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

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
Switch to desktop for real-world practiceContinue from where you are using one of the options below
Section 1. Chapter 7
AVAILABLE TO ULTIMATE ONLY
We're sorry to hear that something went wrong. What happened?
some-alt