Python xlwings模塊簡單使用xlwings 安裝

xlwings excel-book-打開-新建

xlwings sheet-api

xlwings 操作數據

xlwings 讀取數據

xlwings 安裝操作excel模塊的比較

xlwings官方文檔

基本操作

安裝

pip install xlwings

xlwings 打開-新建打開excel文件

多個excel操作import?????????????????time??????????????import?????????????????xlwings

as?????????????????xw??????????????"""?visible?Ture：可見excel?False：不可見excel?add_book?True:打開excel并且新建工作簿?False：不新建工作簿?"""????????????????app

=?????????????????xw??????????????.????????????????App??????????????(????????????????visible??????????????=????????????????True????????????????,?????????????????add_book??????????????=????????????????False????????????????)????????????????wb

=?????????????????app??????????????.????????????????books??????????????.????????????????open????????????????(????????????????'./a.xlsx'????????????????)????????????????wb2

=?????????????????app??????????????.????????????????books??????????????.????????????????open????????????????(????????????????"./b.xlsx"????????????????)????????????????#?打印當前活躍的books-??print????????????????(????????????????app??????????????.????????????????books??????????????.????????????????active??????????????)????????????????#?打印當前的book-Books([,])??print????????????????(????????????????app??????????????.????????????????books??????????????)????????????????wb??????????????.????????????????save??????????????(????????????????)????????????????#?關閉a.xlsx文件-指定操作的excel????????????????#?wb.close()????????????????app??????????????.????????????????books??????????????[????????????????0????????????????]????????????????.????????????????close??????????????(????????????????)????????????????time??????????????.????????????????sleep??????????????(????????????????3????????????????)????????????????app??????????????.????????????????quit??????????????(????????????????)

新建excel文件import?????????????????xlwings

as?????????????????xw

app

=?????????????????xw??????????????.????????????????App??????????????(????????????????visible??????????????=????????????????True????????????????,?????????????????add_book??????????????=????????????????False????????????????)????????????????#?添加一個新的工作薄????????????????wb

=?????????????????app??????????????.????????????????books??????????????.????????????????add??????????????(????????????????)????????????????#?保存文件????????????????wb??????????????.????????????????save??????????????(????????????????'./a2.xlsx'????????????????)????????????????wb??????????????.????????????????close??????????????(????????????????)????????????????app??????????????.????????????????quit??????????????(????????????????)

xlwings sheet-api新建sheetwb.sheets.add("sheet2")

刪除sheetwb??????????????.????????????????sheets??????????????[????????????????"sheet2"????????????????]????????????????.????????????????delete??????????????(????????????????)

查看當前表格名wb??????????????.????????????????sheets??????????????[????????????????1????????????????]????????????????.????????????????name

重命名表格sheetwb??????????????.????????????????sheets??????????????[????????????????1????????????????]????????????????.????????????????name??????????????=????????????????“abc”

清空整張表格的內容和格式wb??????????????.????????????????sheets??????????????[????????????????1????????????????]????????????????.????????????????clear??????????????(????????????????)

查看當前活躍的sheetwb??????????????.????????????????sheets??????????????.????????????????active

sh

=?????????????????wb??????????????.????????????????sheets??????????????.????????????????active

sh??????????????.????????????????range????????????????(????????????????"A1"????????????????)????????????????.????????????????value??????????????=????????????????"A1"

激活指定的sheetwb??????????????.????????????????sheets??????????????[????????????????"sheet1"????????????????]????????????????.????????????????activate??????????????(????????????????)

xlwings 操作數據引用單元格import?????????????????xlwings

as?????????????????xw??????????????import?????????????????time

app

=?????????????????xw??????????????.????????????????App??????????????(????????????????visible??????????????=????????????????True????????????????,?????????????????add_book??????????????=????????????????False????????????????)????????????????wb

=?????????????????app??????????????.????????????????books??????????????.????????????????open????????????????(????????????????"./a.xlsx"????????????????)????????????????sht

=?????????????????wb??????????????.????????????????sheets??????????????[????????????????"sheet1"????????????????]????????????????#?TODO?待輸入-見下面示例????????????????#?A1?單元格????????????????wb??????????????.????????????????sheets??????????????[????????????????"sheet1"????????????????]????????????????.????????????????range????????????????(????????????????"A1"????????????????)????????????????#?A2?單元格????????????????sht??????????????.????????????????range????????????????(????????????????"A2"????????????????)????????????????#?A3單元格-xw-當前活躍的app-book-sheet????????????????xw??????????????.????????????????Range??????????????(????????????????"A3"????????????????)????????????????#?A4單元格????????????????rng_a4

=?????????????????sht??????????????[????????????????"A4"????????????????]????????????????#?A1:B3?單元格????????????????rng_a1_b3

=?????????????????sht??????????????[????????????????"A1:B3"????????????????]????????????????rng_a1_b3_2

=?????????????????sht??????????????.????????????????range????????????????(????????????????"A1:B3"????????????????)????????????????xw??????????????.????????????????Range??????????????(????????????????(????????????????1????????????????,????????????????1????????????????)????????????????,????????????????(????????????????3????????????????,????????????????2????????????????)????????????????)????????????????#?C1單元格????????????????rng_c1

=?????????????????sht??????????????[????????????????0????????????????,????????????????2????????????????]????????????????time??????????????.????????????????sleep??????????????(????????????????3????????????????)????????????????wb??????????????.????????????????save??????????????(????????????????)????????????????wb??????????????.????????????????close??????????????(????????????????)????????????????app??????????????.????????????????quit??????????????(????????????????)

寫入數據單個單元格輸入sht??????????????.????????????????range????????????????(????????????????"A1"????????????????)????????????????.????????????????value??????????????=????????????????"A1"

輸入行-- 在A2輸入1,B2輸入2sht??????????????.????????????????range????????????????(????????????????"A2"????????????????)????????????????.????????????????value??????????????=????????????????[????????????????1????????????????,????????????????2????????????????]

輸入行-A3-A4-A5賦值sht??????????????.????????????????range????????????????(????????????????"A3"????????????????)????????????????.????????????????options??????????????(????????????????transpose??????????????=????????????????True????????????????)????????????????.????????????????value?

=????????????????[????????????????"行"????????????????,????????????????"行"????????????????,????????????????"行"????????????????]

輸入表格sht??????????????.????????????????range????????????????(????????????????'A4'????????????????)????????????????.????????????????options??????????????(????????????????expand??????????????=????????????????'table'????????????????)????????????????.????????????????value?

=????????????????[????????????????[????????????????1????????????????,????????????????2????????????????]????????????????,????????????????[????????????????3????????????????,????????????????4????????????????]????????????????]????????????????sht??????????????.????????????????range????????????????(????????????????"A4:B5"????????????????)????????????????.????????????????value

=????????????????[????????????????[????????????????1????????????????,????????????????2????????????????]????????????????,????????????????[????????????????3????????????????,????????????????4????????????????]????????????????]

xlwings 讀取數據讀取sht??????????????.????????????????range????????????????(????????????????"A1"????????????????)????????????????.????????????????value

sht??????????????.????????????????range????????????????(????????????????"A1:A3"????????????????)????????????????.????????????????value

sht??????????????.????????????????range????????????????(????????????????"A1:B3"????????????????)????????????????.????????????????value

xw??????????????.????????????????Range??????????????(????????????????"A1"????????????????)????????????????.????????????????value

更多文章、技術交流、商務合作、聯系博主

微信掃碼或搜索：z360901061

微信掃一掃加我為好友

QQ號聯系：360901061

總結

以上是生活随笔為你收集整理的python3.8安装xlwings出错_Python xlwings模块简单使用的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。