Conteúdo do Curso
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.
Tarefa
- Import
Workbook
fromopenpyxl
; - Select the current active sheet (the
.active
attribute); - Insert
"hello"
in cell"A1"
.
Once you've completed this task, click the button above the code to check your solution.
Tarefa
- Import
Workbook
fromopenpyxl
; - Select the current active sheet (the
.active
attribute); - Insert
"hello"
in cell"A1"
.
Once you've completed this task, click the button above the code to check your solution.
Tudo estava claro?
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.
Tarefa
- Import
Workbook
fromopenpyxl
; - Select the current active sheet (the
.active
attribute); - Insert
"hello"
in cell"A1"
.
Once you've completed this task, click the button above the code to check your solution.