[咨询]xlrd模块有没有办法访问加密文档？(密码已知)

paktc

自己设置的Excel访问密码，
但是如果要用xldr读取里面的内容，好像又没有相应的方法去填写密码。{: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里对excel的操作moudle是不是不强

paktc

回复 3# 怪怪虎

感觉也不弱，而且可以访问office的函数接口，有些教程有介绍

相关的模块
http://packages.python.org/openpyxl/
openpyxl - A Python library to read/write Excel 2007 xlsx/xlsm files

相关博文
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/