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
course content

Course Content

Excel Automation with Python

Excel Automation with Python

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

bookOpen, 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
Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

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 desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Section 1. Chapter 7
AVAILABLE TO ULTIMATE ONLY
some-alt