Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Leer Load Workbook | Excel Automation with Python (project)
Excel Automation with Python (project)
course content

Cursusinhoud

Excel Automation with Python (project)

Excel Automation with Python (project)

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.

Taak

Swipe to start coding

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

Oplossing

Mark tasks as Completed
Switch to desktopSchakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande opties
Was alles duidelijk?

Hoe kunnen we het verbeteren?

Bedankt voor je feedback!

Sectie 1. Hoofdstuk 4
AVAILABLE TO ULTIMATE ONLY
some-alt