[咨詢]xlrd模塊有沒有辦法訪問(wèn)加密文檔？(密碼已知)

paktc

自己設(shè)置的Excel訪問(wèn)密碼，
但是如果要用xldr讀取里面的內(nèi)容，好像又沒有相應(yīng)的方法去填寫密碼。{:2_166:}

  File "C:\Python27\lib\site-packages\xlrd\__init__.py", line 1017, in handle_filepass
    raise XLRDError("Workbook is encrypted"
XLRDError: Workbook is encrypted

難道只能取消加密了嗎 {:2_169:}

paktc

好吧 ，看了一下官方README

http://www.lexicon.net/sjmachin/README.html

Unlikely to be done:

    Handling password-protected (encrypted) files.

怪怪虎

python里對(duì)excel的操作moudle是不是不強(qiáng)

paktc

回復(fù) 3# 怪怪虎

感覺也不弱，而且可以訪問(wèn)office的函數(shù)接口，有些教程有介紹

相關(guān)的模塊
http://packages.python.org/openpyxl/
openpyxl - A Python library to read/write Excel 2007 xlsx/xlsm files

相關(guān)博文
http://blog.csdn.net/hxsyewlink/article/details/6265790
openpyxl 讀寫excel2007使用筆記

https://bitbucket.org/wensheng/pyooxml/wiki/Home
下載
http://pypi.python.org/pypi/ooxml/0.2.1

模塊/資料連接
http://www.python-excel.org/

xlrd
This package is for reading data and formatting information from Excel files.、

xlwt
This package is for writing data and formatting information to Excel files.

xlutils
This package collects utilities that require both xlrd and xlwt, including the ability to copy and modify or filter existing excel files.

xlrd中文資料
Python Excel Tutorial 指南
http://www.iteye.com/topic/1114817

同上
http://blog.csdn.net/linking530/article/details/8024212


博文：用Python修改Excel文件
http://www.zhlwish.com/2010/10/09/python_edit_excel/