Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Load Workbook | 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

bookLoad Workbook

load_workbook() is a method provided by the openpyxl library in Python that allows you to load an existing Excel workbook from a file into memory. The load_workbook() method takes a filename as a parameter and returns a workbook object that represents the file's contents.

Tarefa

  1. Load a workbook called "sample_data.xlsx";
  2. Print the sheetnames;
  3. Print the active sheet.

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!

load_workbook() is a method provided by the openpyxl library in Python that allows you to load an existing Excel workbook from a file into memory. The load_workbook() method takes a filename as a parameter and returns a workbook object that represents the file's contents.

Tarefa

  1. Load a workbook called "sample_data.xlsx";
  2. Print the sheetnames;
  3. Print the active sheet.

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 4
AVAILABLE TO ULTIMATE ONLY
some-alt