Python自动化：从新手到解决枯燥任务

用Python编写简单自动化任务脚本 #生活乐趣# #日常生活趣事# #生活趣味分享# #科技小发明#

xvi Contents in Detail

Summary ...................................................... 261

Practice Questions

................................................ 261

Practice Projects.................................................. 262

Command Line Emailer

...................................... 262

Image Site Downloader ...................................... 263

2048................................................... 263

Link Verification

........................................... 263

12

WORKING WITH EXCEL SPREADSHEETS 265

Excel Documents ................................................. 266

Installing the openpyxl Module

....................................... 266

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

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

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

Adjusting Rows and Columns

........................................ 285

Setting Row Height and Column Width

........................... 285

Merging and Unmerging Cells

................................. 286

Freeze Panes

............................................. 287

Charts

........................................................ 288

Summary

...................................................... 290

Practice Questions

................................................ 291

Practice Projects.................................................. 291

Multiplication Table Maker.................................... 291

Blank Row Inserter.......................................... 292

Spreadsheet Cell Inverter ..................................... 292

Text Files to Spreadsheet

..................................... 293

Spreadsheet to Text Files ..................................... 293

网址：Python自动化：从新手到解决枯燥任务 https://www.yuejiaxmz.com/news/view/549856

相关内容

Python自动化任务
Python 简介：用自动化告别手动任务
Python：任务自动化工具
十个自动化日常任务的Python脚本
利用Python自动化日常任务
分享10个Python脚本，轻松让日常任务自动化
从零开始构建：Python自定义脚本自动化你的日常任务
AppTask: 使用Python实现日常APP任务自动化
【定时任务学习】新手指南：轻松上手任务自动化
10个Python脚本自动化日常任务

随便看看