Зміст курсу
Excel Automation with Python
Create Workbook
Workbook() is a function provided by the openpyxl library in Python that creates a new Excel workbook object. A workbook is the main container for all the data and information in an Excel file, including worksheets, charts, and macros.
The Workbook() function initializes a new workbook object and provides methods to create, modify, and save the workbook to a file. The workbook can have one or more worksheets, each containing a grid of cells arranged in rows and columns.
Завдання
- Import
Workbookfromopenpyxl; - Select the current active sheet (the
.activeattribute); - Insert
"hello"in cell"A1".
Once you've completed this task, click the button above the code to check your solution.
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантівДякуємо за ваш відгук!
Workbook() is a function provided by the openpyxl library in Python that creates a new Excel workbook object. A workbook is the main container for all the data and information in an Excel file, including worksheets, charts, and macros.
The Workbook() function initializes a new workbook object and provides methods to create, modify, and save the workbook to a file. The workbook can have one or more worksheets, each containing a grid of cells arranged in rows and columns.
Завдання
- Import
Workbookfromopenpyxl; - Select the current active sheet (the
.activeattribute); - Insert
"hello"in cell"A1".
Once you've completed this task, click the button above the code to check your solution.
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів