Python Xlrd模块学习

背景

折腾：

【整理】Python中，添加写入数据到已经存在的Excel的xls文件，即打开excel文件，写入新数据

的过程中，需要用到xlrd。

所以去安装。

下载xlrd

从：

Working with Excel Files in Python

提到的

http://pypi.python.org/pypi/xlrd

去下载，最新版本的

xlrd-0.8.0.tar.gz

得到130KB的xlrd-0.8.0.tar.gz

 

安装xlrd

解压后，打开cmd切换到对应目录，去执行：

?

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

D:\tmp\dev_tools\python\excel\xlrd-0.8.0\xlrd-0.8.0>setup.pyinstall

running install

running build

running build_py

creating build

creating build\lib

creating build\lib\xlrd

copying xlrd\biffh.py -> build\lib\xlrd

copying xlrd\book.py -> build\lib\xlrd

copying xlrd\compdoc.py -> build\lib\xlrd

copying xlrd\formatting.py -> build\lib\xlrd

copying xlrd\formula.py -> build\lib\xlrd

copying xlrd\info.py -> build\lib\xlrd

copying xlrd\licences.py -> build\lib\xlrd

copying xlrd\sheet.py -> build\lib\xlrd

copying xlrd\timemachine.py -> build\lib\xlrd

copying xlrd\xldate.py -> build\lib\xlrd

copying xlrd\xlsx.py -> build\lib\xlrd

copying xlrd\__init__.py -> build\lib\xlrd

creating build\lib\xlrd\doc

copying xlrd\doc\compdoc.html -> build\lib\xlrd\doc

copying xlrd\doc\xlrd.html -> build\lib\xlrd\doc

creating build\lib\xlrd\examples

copying xlrd\examples\namesdemo.xls -> build\lib\xlrd\examples

copying xlrd\examples\xlrdnameAPIdemo.py -> build\lib\xlrd\examples

running build_scripts

creating build\scripts-2.7

copying scripts\runxlrd.py -> build\scripts-2.7

running install_lib

creating D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd

copying build\lib\xlrd\biffh.py -> D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd

copying build\lib\xlrd\book.py -> D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd

copying build\lib\xlrd\compdoc.py -> D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd

creating D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\doc

copying build\lib\xlrd\doc\compdoc.html -> D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\doc

copying build\lib\xlrd\doc\xlrd.html -> D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\doc

creating D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\examples

copying build\lib\xlrd\examples\namesdemo.xls -> D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\examples

copying build\lib\xlrd\examples\xlrdnameAPIdemo.py -> D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\examples

copying build\lib\xlrd\formatting.py -> D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd

copying build\lib\xlrd\formula.py -> D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd

copying build\lib\xlrd\info.py -> D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd

copying build\lib\xlrd\licences.py -> D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd

copying build\lib\xlrd\sheet.py -> D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd

copying build\lib\xlrd\timemachine.py -> D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd

copying build\lib\xlrd\xldate.py -> D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd

copying build\lib\xlrd\xlsx.py -> D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd

copying build\lib\xlrd\__init__.py -> D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd

byte-compiling D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\biffh.py to biffh.pyc

byte-compiling D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\book.py to book.pyc

byte-compiling D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\compdoc.py to compdoc.pyc

byte-compiling D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\examples\xlrdnameAPIdemo.py to xlrdnameAPIdemo.pyc

byte-compiling D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\formatting.py to formatting.pyc

byte-compiling D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\formula.py to formula.pyc

byte-compiling D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\info.py to info.pyc

byte-compiling D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\licences.py to licences.pyc

byte-compiling D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\sheet.py to sheet.pyc

byte-compiling D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\timemachine.py to timemachine.pyc

byte-compiling D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\xldate.py to xldate.pyc

byte-compiling D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\xlsx.py to xlsx.pyc

byte-compiling D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd\__init__.py to __init__.pyc

running install_scripts

copying build\scripts-2.7\runxlrd.py -> D:\tmp\dev_install_root\Python27_x64\Scripts

running install_egg_info

Writing D:\tmp\dev_install_root\Python27_x64\Lib\site-packages\xlrd-0.8.0-py2.7.egg-info

 

D:\tmp\dev_tools\python\excel\xlrd-0.8.0\xlrd-0.8.0>

 

总结

接着可以去继续折腾了：

【整理】Python中，添加写入数据到已经存在的Excel的xls文件，即打开excel文件，写入新数据