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

Contenido del 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.

Tarea

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

Mark tasks as Completed
Switch to desktopCambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones
¿Todo estuvo claro?

¿Cómo podemos mejorarlo?

¡Gracias por tus comentarios!

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.

Tarea

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

Mark tasks as Completed
Switch to desktopCambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones
Sección 1. Capítulo 4
AVAILABLE TO ULTIMATE ONLY
some-alt