《讓Python遇上Office——從編程入門到自動化辦公實踐》是2023年8月1日清華大學出版社出版的圖書，作者：潘美冰。
基本介紹
- 中文名：讓Python遇上Office——從編程入門到自動化辦公實踐
- 作者：潘美冰
- 出版時間：2023年8月1日
- 出版社：清華大學出版社
- ISBN：9787302637882
- 定價：89 元
- 印次：1-1
- 印刷日期：2023.08.09
內容簡介,圖書目錄,
內容簡介
Python 是目前***的程式語言之一。本書將從零開始教讀者如何通過 Python 實現辦 公自動化。全書共 10 章，分為 3 部分：第一部分（第 1~5 章）包括從零基礎入門 Python 的 基礎知識（數據類型、函式、類與對象、捕獲異常、檔案操作、管理模組等）；第二部分（第 6~9 章）以操作辦公文檔為主，介紹如何使用 Python 代碼處理 Word、Excel、PPT、PDF 文檔， 實現文檔辦公自動化；第三部分（第 10 章）為進階部分，內容涉及桌面自動化、傳送郵件、 網路請求、定時任務、GUI、打包程式等，可以幫助讀者進一步提高工作效率。本書代碼邏 輯完整清晰，強調各種易錯點，以便讀者在學習過程中實現效率**化。讀者可以將本書案 例當成模板。 本書適合想要學習 Python 語言的在校師生或職場辦公人員，也適合零基礎的學習者入 門 python 編程。
圖書目錄
目 錄
第一部分 Python基礎知識
第1章 Python安裝環境
1.1 認識Python ..........................................................................................................1
1.2 安裝Python ..........................................................................................................2
1.2.1 在Windows系統安裝Python .......................................................................................2
1.2.2 在macOS安裝Python ...................................................................................................6
1.3 安裝Pycharm .......................................................................................................9
1.3.1 安裝Windows版Pycharm ..........................................................................................10
1.3.2 安裝macOS版Pycharm ..............................................................................................14
1.4 第一行代碼 ........................................................................................................17
1.4.1 互動環境 ......................................................................................................................17
1.4.2 運行py檔案 ................................................................................................................18
1.4.3 在Pycharm中運行 ......................................................................................................18
1.5 簡單互動 ............................................................................................................22
1.5.1 注釋 ..............................................................................................................................22
1.5.2 輸出 ..............................................................................................................................22
1.5.3 輸入 ..............................................................................................................................23
1.5.4 變數 ..............................................................................................................................24
讓Python遇上Office——從編程入門到自動化辦公實踐IV
第2章 數據結構
2.1 數字類型 ............................................................................................................26
2.1.1 整型 ..............................................................................................................................26
2.1.2 浮點型 ..........................................................................................................................27
2.1.3 布爾型 ..........................................................................................................................27
2.1.4 複數 ..............................................................................................................................27
2.2 字元串 ................................................................................................................28
2.2.1 字元編碼 ......................................................................................................................28
2.2.2 字元串 ..........................................................................................................................30
2.2.3 轉義字元 ......................................................................................................................31
2.2.4 字元串索引 ..................................................................................................................32
2.2.5 字元串切片 ..................................................................................................................33
2.2.6 查詢元素 ......................................................................................................................34
2.2.7 拼接字元串 ..................................................................................................................35
2.2.8 類型轉換 ......................................................................................................................35
2.2.9 替換字元串 ..................................................................................................................36
2.2.10 大小寫轉換 ................................................................................................................37
2.2.11 分割字元串.................................................................................................................37
2.2.12 格式化字元串.............................................................................................................37
2.3 列表 ....................................................................................................................39
2.3.1 新建列表 ......................................................................................................................39
2.3.2 查詢列表元素 ..............................................................................................................40
2.3.3 增加列表元素 ..............................................................................................................41
2.3.4 修改列表元素 ..............................................................................................................41
2.3.5 刪除列表元素 ..............................................................................................................41
2.3.6 合併多個列表 ..............................................................................................................43
2.3.7 列表元素統計 ..............................................................................................................43
2.4 元組 ....................................................................................................................44
2.4.1 新建元組 ......................................................................................................................44
2.4.2 訪問元組 ......................................................................................................................45
2.5 字典 ....................................................................................................................45
2.5.1 新建字典 ......................................................................................................................46
2.5.2 訪問字典元素 ..............................................................................................................47
2.5.3 增加字典元素 ..............................................................................................................48
2.5.4 修改字典元素 ..............................................................................................................48
2.5.5 刪除字典元素 ..............................................................................................................49
2.6 集合 ....................................................................................................................50
2.6.1 新建集合 ......................................................................................................................50
2.6.2 交差並補 ......................................................................................................................51
2.6.3 增加集合元素 ..............................................................................................................52
2.6.4 刪除集合元素 ..............................................................................................................52
2.7 None類型...........................................................................................................53
2.8 可變類型與拷貝 .................................................................................................53
2.8.1 可變類型和不可變類型 ...............................................................................................53
2.8.2 淺拷貝與深拷貝 ...........................................................................................................55
2.9 公共方法 ............................................................................................................56
2.10 運算符 ..............................................................................................................57
2.10.1 算術運算符 ................................................................................................................58
2.10.2 比較運算符 ................................................................................................................58
2.10.3 賦值運算符 ................................................................................................................59
2.10.4 邏輯運算符 ................................................................................................................60
2.10.5 成員運算符 ................................................................................................................61
2.10.6 身份運算符 ................................................................................................................62
2.11 遍歷 ..................................................................................................................63
2.12 推導式 ..............................................................................................................64
第3章 函式
3.1 三大基本結構 ....................................................................................................67
3.1.1 順序結構 ......................................................................................................................67
3.1.2 選擇結構 ......................................................................................................................67
3.1.3 循環結構 ......................................................................................................................70
3.2 認識函式 ............................................................................................................74
3.3 函式參數 ............................................................................................................76
3.3.1 形參與實參 ..................................................................................................................76
3.3.2 默認參數 ......................................................................................................................77
3.3.3 不定長參數 ..................................................................................................................78
3.4 函式返回值 ........................................................................................................78
3.5 組包和解包 ........................................................................................................79
3.6 變數作用域 ........................................................................................................82
3.7 lambda函式 .......................................................................................................83
第4章 類與對象
4.1 類與對象 ............................................................................................................85
4.1.1 實例化對象 ..................................................................................................................85
4.1.2 初始化方法 ..................................................................................................................86
4.1.3 對象屬性與方法 ...........................................................................................................87
4.2 私有屬性和私有方法 .........................................................................................89
4.3 魔法方法 ............................................................................................................91
4.3.1 對象的生命周期 ...........................................................................................................92
4.3.2 可疊代對象 ..................................................................................................................93
4.4 繼承與多態 ........................................................................................................95
4.4.1 繼承 ..............................................................................................................................96
4.4.2 多態 ..............................................................................................................................97
4.5 類方法與靜態方法 .............................................................................................99
4.5.1 裝飾器 ..........................................................................................................................99
4.5.2 類方法 ..........................................................................................................................99
4.5.3 靜態方法 ....................................................................................................................101
4.5.4 屬性裝飾器 ................................................................................................................101
第5章 其他知識點
5.1 程式異常 ..........................................................................................................103
5.1.1 捕獲異常 ....................................................................................................................103
5.1.2 主動拋異常 ................................................................................................................105
5.1.3 debug程式 .................................................................................................................107
5.2 檔案讀寫 ..........................................................................................................108
5.2.1 open函式 ...................................................................................................................108
5.2.2 上下文管理器 ............................................................................................................111
5.3 模組與包 ..........................................................................................................113
5.3.1 模組 ............................................................................................................................113
5.3.2 包 ................................................................................................................................115
5.3.3 pip管理器 ..................................................................................................................116
5.4 常用模組 ..........................................................................................................117
5.4.1 datetime ......................................................................................................................117
5.4.2 decimal .......................................................................................................................119
5.4.3 os ................................................................................................................................121
第二部分 Python辦公知識
第6章 操作Excel
6.1 openpyxl ...........................................................................................................124
6.2 打開與保存 ......................................................................................................126
6.2.1 新建工作簿 ................................................................................................................126
6.2.2 保存工作簿 ................................................................................................................126
6.2.3 打開工作簿 ................................................................................................................128
6.3 操作工作表 ......................................................................................................128
6.3.1 獲取默認工作表 .........................................................................................................128
6.3.2 工作表屬性 ................................................................................................................129
6.3.3 獲取工作表 ................................................................................................................130
6.3.4 新建工作表 ................................................................................................................131
6.3.5 刪除工作表 ................................................................................................................132
6.3.6 移動工作表 ................................................................................................................132
6.3.7 複製工作表 ................................................................................................................133
6.4 訪問單元格 ......................................................................................................133
6.4.1 獲取單個單元格 .........................................................................................................134
6.4.2 單元格屬性 ................................................................................................................134
6.4.3 修改單元格 ................................................................................................................135
6.4.4 獲取多個單元格 .........................................................................................................137
6.5 操作單元格 ......................................................................................................142
6.5.1 合併單元格 ................................................................................................................142
6.5.2 插入和刪除行列 .........................................................................................................144
6.5.3 移動單元格 ................................................................................................................145
6.6 使用公式 ..........................................................................................................146
6.6.1 可用公式 ....................................................................................................................146
6.6.2 使用公式 ....................................................................................................................147
6.6.3 翻譯公式 ....................................................................................................................148
6.7 設定樣式 ..........................................................................................................150
6.7.1 字型樣式 ....................................................................................................................150
6.7.2 行高列寬 ....................................................................................................................151
6.7.3 對齊方式 ....................................................................................................................152
6.7.4 框線樣式 ....................................................................................................................153
6.7.5 填充漸變 ....................................................................................................................153
6.8 過濾和排序 ......................................................................................................154
6.9 插入圖表 ..........................................................................................................157
6.10 唯讀只寫 ........................................................................................................160
6.10.1 只寫模式 ..................................................................................................................160
6.10.2 唯讀模式 ..................................................................................................................161
6.11 加密保護 ........................................................................................................162
6.11.1 保護工作簿...............................................................................................................162
6.11.2 保護工作表...............................................................................................................164
6.11.3 加密文檔 ..................................................................................................................165
6.12 xls轉xlsx .......................................................................................................166
第7章 操作Word7.1 python-docx.......................................................................................168
7.2 打開與保存 ......................................................................................................168
7.2.1 新建文檔 ....................................................................................................................168
7.2.2 保存文檔 ....................................................................................................................168
7.2.3 打開文檔 ....................................................................................................................169
7.3 doc轉docx .......................................................................................................170
7.4 段落操作 ..........................................................................................................171
7.4.1 段落 ............................................................................................................................171
7.4.2 增刪段落 ....................................................................................................................173
7.5 段落樣式 ..........................................................................................................175
7.5.1 段落對齊 ....................................................................................................................175
7.5.2 使用內置樣式 ............................................................................................................176
7.5.3 間距和縮進 ................................................................................................................178
7.5.4 刪除段落樣式 ............................................................................................................179
7.6 Run對象 ..........................................................................................................180
7.6.1 認識Run.....................................................................................................................180
7.6.2 添加Run.....................................................................................................................181
7.6.3 清空Run.....................................................................................................................182
7.6.4 Run樣式.....................................................................................................................182
7.6.5 案例：社團證明 .........................................................................................................185
7.7 長度單位 ..........................................................................................................190
7.7.1 Emu ............................................................................................................................190
7.7.2 單位轉換 ....................................................................................................................191
7.7.3 中文字元長度 ............................................................................................................192
7.8 使用標題 ..........................................................................................................193
7.8.1 添加標題 ....................................................................................................................194
7.8.2 標題與段落的關係 .....................................................................................................195
7.9 操作圖片 ..........................................................................................................196
7.9.1 插入圖片 ....................................................................................................................196
7.9.2 查看圖片 ....................................................................................................................198
7.9.3 刪除圖片 ....................................................................................................................199
7.9.4 圖片尺寸 ....................................................................................................................200
7.9.5 圖片對齊 ....................................................................................................................202
7.9.6 浮動圖片 ....................................................................................................................202
7.9.7 提取圖片 ....................................................................................................................205
7.10 操作表格 ........................................................................................................206
7.10.1 插入表格 ..................................................................................................................206
7.10.2 添加行列 ..................................................................................................................207
7.10.3 行列對象 ..................................................................................................................207
7.10.4 單元格對象 ..............................................................................................................209
7.10.5 修改單元格 ..............................................................................................................209
7.10.6 合併單元格 ..............................................................................................................211
7.10.7 單元格樣式 ..............................................................................................................211
7.10.8 表格樣式 ..................................................................................................................213
7.11 頁面設定 ........................................................................................................214
7.11.1 使用節 ......................................................................................................................215
7.11.2 分節符 ......................................................................................................................215
7.11.3 紙張大小 ..................................................................................................................216
7.11.4 紙張方向 ..................................................................................................................217
7.11.5 頁邊距 ......................................................................................................................218
7.11.6 裝訂線 ......................................................................................................................219
7.11.7 頁眉頁腳 ..................................................................................................................219
7.11.8 奇偶頁不同...............................................................................................................222
7.11.9 首頁不同 ..................................................................................................................223
第8章 操作PPT8.1 python-pptx..........................................................................................225
8.2 打開與保存 ......................................................................................................225
8.2.1 新建和保存 ................................................................................................................225
8.2.2 打開文檔 ....................................................................................................................226
8.2.3 ppt轉pptx ..................................................................................................................226
8.3 長度單位 ..........................................................................................................227
8.3.1 長度單位 ....................................................................................................................227
8.3.2 單位轉換 ....................................................................................................................227
8.4 操作幻燈片 ......................................................................................................228
8.4.1 幻燈片布局 ................................................................................................................228
8.4.2 新建幻燈片 ................................................................................................................229
8.4.3 幻燈片位置 ................................................................................................................230
8.4.4 獲取幻燈片 ................................................................................................................230
8.4.5 刪除幻燈片 ................................................................................................................231
8.5 使用形狀 ..........................................................................................................232
8.5.1 了解形狀 ....................................................................................................................232
8.5.2 獲取形狀 ....................................................................................................................233
8.5.3 添加形狀 ....................................................................................................................234
8.5.4 形狀填充色 ................................................................................................................236
8.5.5 形狀框線 ....................................................................................................................237
8.6 使用占位符 ......................................................................................................237
8.6.1 了解占位符 ................................................................................................................237
8.6.2 獲取占位符 ................................................................................................................238
8.6.3 占位符類型 ................................................................................................................239
8.6.4 填充占位符 ................................................................................................................240
8.7 操作文本 ..........................................................................................................243
8.7.1 獲取文本框 ................................................................................................................243
8.7.2 添加文本框 ................................................................................................................243
8.7.3 添加文本 ....................................................................................................................244
8.7.4 段落樣式 ....................................................................................................................245
8.7.5 Run樣式.....................................................................................................................246
8.7.6 文本框樣式 ................................................................................................................247
8.8 添加圖表 ..........................................................................................................249
8.8.1 柱狀圖 ........................................................................................................................249
8.8.2 折線圖 ........................................................................................................................253
8.8.3 散點圖 ........................................................................................................................255
8.8.4 餅圖 ............................................................................................................................258
8.8.5 占位符圖表 ................................................................................................................260
8.9 操作表格 ..........................................................................................................261
8.9.1 插入表格 ....................................................................................................................261
8.9.2 讀取表格 ....................................................................................................................262
8.9.3 占位符表格 ................................................................................................................263
8.9.4 表格對象 ....................................................................................................................263
8.9.5 行列對象 ....................................................................................................................264
8.9.6 訪問單元格 ................................................................................................................265
8.9.7 單元格文本 ................................................................................................................266
8.9.8 單元格樣式 ................................................................................................................266
8.9.9 合併單元格 ................................................................................................................267
8.9.10 拆分單元格 ..............................................................................................................269
8.10 操作圖片 ........................................................................................................270
8.10.1 添加圖片 ..................................................................................................................270
8.10.2 提取圖片 ..................................................................................................................271
8.10.3 頁面保存為圖片 .......................................................................................................272
第9章 操作PDF9.1 pypdf2 ...............................................................................................273
9.2 打開與保存PDF檔案.....................................................................................273
9.2.1 保存文檔 ....................................................................................................................273
9.2.2 讀取文檔 ....................................................................................................................274
9.2.3 文檔尺寸 ....................................................................................................................274
9.3 操作頁面 ..........................................................................................................275
9.3.1 讀取頁面 ....................................................................................................................275
9.3.2 保存頁面 ....................................................................................................................275
9.3.3 合併文檔 ....................................................................................................................276
9.4 修改PDF..........................................................................................................278
9.4.1 旋轉頁面 ....................................................................................................................278
9.4.2 縮放頁面 ....................................................................................................................279
9.4.3 裁剪頁面 ....................................................................................................................281
9.5 提取內容 ..........................................................................................................283
9.5.1 提取文本 ....................................................................................................................283
9.5.2 提取圖片 ....................................................................................................................284
9.6 添加水印 ..........................................................................................................285
9.7 讀寫元數據 ......................................................................................................286
9.7.1 查看元數據 ................................................................................................................286
9.7.2 更新元數據 ................................................................................................................286
9.8 加密解密 ..........................................................................................................287
9.8.1 加密文檔 ....................................................................................................................287
9.8.2 解密文檔 ....................................................................................................................288
9.9 轉換PDF..........................................................................................................288
9.9.1 Word轉PDF ..............................................................................................................288
9.9.2 Excel轉PDF ..............................................................................................................289
9.9.3 PPT轉PDF ................................................................................................................290
9.9.4 PDF轉Word ..............................................................................................................291
第三部分 進階內容
第10章 其他操作
10.1 自動單擊 ........................................................................................................293
10.1.1 pyautogui ..................................................................................................................293
10.1.2 螢幕信息 ..................................................................................................................294
10.1.3 滑鼠操作 ..................................................................................................................294
10.1.4 鍵盤操作 ..................................................................................................................296
10.1.5 信息彈窗 ..................................................................................................................297
10.1.6 圖片定位 ..................................................................................................................298
10.1.7 記事本案例 ..............................................................................................................299
10.2 傳送郵件 ........................................................................................................300
10.2.1 開啟SMTP ...............................................................................................................301
10.2.2 傳送純文本郵件 .......................................................................................................301
10.2.3 傳送郵件附屬檔案...........................................................................................................303
10.3 網路請求 ........................................................................................................306
10.3.1 Web相關概念 ..........................................................................................................306
10.3.2 請求網路資源...........................................................................................................308
10.3.3 第三方API ...............................................................................................................309
10.3.4 發起網路請求...........................................................................................................312
10.3.5 處理JSON ................................................................................................................313
10.4 定時任務 ........................................................................................................317
10.4.1 安裝apshedule .........................................................................................................317
10.4.2 簡單使用 ..................................................................................................................317
10.4.3 調度器 ......................................................................................................................318
10.4.4 觸發器 ......................................................................................................................318
10.4.5 管理定時任務...........................................................................................................320
10.4.6 修改定時任務...........................................................................................................322
10.4.7 定時任務案例...........................................................................................................323
10.5 圖形用戶界面 ................................................................................................324
10.5.1 PySimpleGUI ............................................................................................................325
10.5.2 第一個GUI ..............................................................................................................325
10.5.3 Window對象 ............................................................................................................326
10.5.4 布局 ..........................................................................................................................328
10.5.5 單擊事件 ..................................................................................................................329
10.5.6 文本元素 ..................................................................................................................330
10.5.7 更新元素 ..................................................................................................................332
10.5.8 輸入框元素 ..............................................................................................................333
10.5.9 按鈕元素 ..................................................................................................................334
10.5.10 檔案選擇框 ............................................................................................................335
10.5.11 彈窗 ........................................................................................................................337
10.5.12 GUI版ppt轉pptx .................................................................................................338
10.6 打包程式 ........................................................................................................340
10.6.1 pyinstaller .................................................................................................................340
10.6.2 虛擬環境 ..................................................................................................................342
結束語 ....................................................................................346
