Please enable JavaScript.
Coggle requires JavaScript to display documents.
12 Working with Excel Spreadsheets 265 ((Project: Updating a…
12
Working with Excel Spreadsheets 265
Excel Documents . 266
Installing the openpyxl Module . 266
Adjusting Rows and Columns . 285
Setting Row Height and Column Width . 285
Merging and Unmerging Cells . 286
Freeze Panes . 287
Charts . 288
Writing Excel Documents . 277
Creating and Saving Excel Documents 277
Creating and Removing Sheets 278
Writing Values to Cells . 278
Project: Updating a Spreadsheet . 279
Step 1: Set Up a Data Structure with the Update Information . 280
Step 2: Check All Rows and Update Incorrect Prices . 281
Ideas for Similar Programs 281
Setting the Font Style of Cells 282
Font Objects . 282
Formulas 284
Project: Reading Data from a Spreadsheet . 272
Step 1: Read the Spreadsheet Data 273
Step 2: Populate the Data Structure 274
Step 3: Write the Results to a File . 275
Ideas for Similar Programs 276
Reading Excel Documents 266
Opening Excel Documents with OpenPyXL 267
Getting Sheets from the Workbook . 268
Getting Cells from the Sheets . 268
Converting Between Column Letters and Numbers 270
Getting Rows and Columns from the Sheets . 270
Workbooks, Sheets, Cells . 272