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

Conteúdo do Curso

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":

Tarefa
test

Swipe to show code editor

  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 desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

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

Tarefa
test

Swipe to show code editor

  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 desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Seção 1. Capítulo 7
AVAILABLE TO ULTIMATE ONLY
We're sorry to hear that something went wrong. What happened?
some-alt