Python 一个简单的读取excel例

hanruikaideMacBook-Pro:local hanruikai$ python
Python 2.7.10 (default, Feb  7 2017, 00:08:15) 
[GCC 4.2.1 Compatible Apple LLVM 8.0.0 (clang-800.0.34)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> ^D

hanruikaideMacBook-Pro:bin hanruikai$ pwd
/usr/local/bin
hanruikaideMacBook-Pro:bin hanruikai$ ls 
2to3                    brew                    express                 idle3.6                 npm                     pip3                    pydoc3                  python3                 python3.6               python3.6m              pyvenv
2to3-3.6                easy_install-3.6        idle3                   node                    npx                     pip3.6                  pydoc3.6                python3-config          python3.6-config        python3.6m-config       pyvenv-3.6
hanruikaideMacBook-Pro:bin hanruikai$ 

hanruikaideMacBook-Pro:bin hanruikai$ pip
bash: pip: command not found
hanruikaideMacBook-Pro:bin hanruikai$ pip3

Usage:   
  pip <command> [options]

Commands:
  install                     Install packages.
  download                    Download packages.
  uninstall                   Uninstall packages.
  freeze                      Output installed packages in requirements format.
  list                        List installed packages.
  show                        Show information about installed packages.
  check                       Verify installed packages have compatible dependencies.
  search                      Search PyPI for packages.
  wheel                       Build wheels from your requirements.
  hash                        Compute hashes of package archives.
  completion                  A helper command used for command completion.
  help                        Show help for commands.

General Options:
  -h, --help                  Show help.
  --isolated                  Run pip in an isolated mode, ignoring environment variables and user configuration.
  -v, --verbose               Give more output. Option is additive, and can be used up to 3 times.
  -V, --version               Show version and exit.
  -q, --quiet                 Give less output. Option is additive, and can be used up to 3 times (corresponding to WARNING, ERROR, and CRITICAL logging levels).
  --log <path>                Path to a verbose appending log.
  --proxy <proxy>             Specify a proxy in the form [user:passwd@]proxy.server:port.
  --retries <retries>         Maximum number of retries each connection should attempt (default 5 times).
  --timeout <sec>             Set the socket timeout (default 15 seconds).
  --exists-action <action>    Default action when a path already exists: (s)witch, (i)gnore, (w)ipe, (b)ackup, (a)bort.
  --trusted-host <hostname>   Mark this host as trusted, even though it does not have valid or any HTTPS.
  --cert <path>               Path to alternate CA bundle.
  --client-cert <path>        Path to SSL client certificate, a single file containing the private key and the certificate in PEM format.
  --cache-dir <dir>           Store the cache data in <dir>.
  --no-cache-dir              Disable the cache.
  --disable-pip-version-check
                              Don't periodically check PyPI to determine whether a new version of pip is available for download. Implied with --no-index.
hanruikaideMacBook-Pro:bin hanruikai$

import xlrd


def read_excel():
    # 打开文件
    workbook = xlrd.open_workbook('/Users/hanruikai/Documents/信用卡分类信息表.xlsx')
    # 获取所有sheet
    print(workbook.sheet_names())  # [u'sheet1', u'sheet2']

    # 根据sheet索引或者名称获取sheet内容
    sheet1 = workbook.sheet_by_index(0)  # sheet索引从0开始

    # sheet的名称，行数，列数
    print(sheet1.name, sheet1.nrows, sheet1.ncols)

    # 获取整行和整列的值（数组）
    rows = sheet1.row_values(3)  # 获取第四行内容
    cols = sheet1.col_values(2)  # 获取第三列内容
    print(rows)
    print(cols)

    # 获取单元格内容
    print(sheet1.cell(1, 0).value.encode('utf-8'))
    print(sheet1.cell_value(1, 0).encode('utf-8'))
    print(sheet1.row(1)[0].value.encode('utf-8'))

    # 获取单元格内容的数据类型
    print(sheet1.cell(1, 0).ctype)


if __name__ == '__main__':
    read_excel()

  # 打开文件
    workbook = xlrd.open_workbook('/Users/hanruikai/Documents/信用卡分类信息表.xlsx')
    # 获取所有sheet
    print(workbook.sheet_names())  # [u'sheet1', u'sheet2']

# 打开文件
workbook = xlrd.open_workbook('/Users/hanruikai/Documents/信用卡分类信息表.xlsx')
# 获取所有sheet
print
workbook.sheet_names() # [u'sheet1', u'sheet2']

hanruikaideMacBook-Pro:eclipse-workspace hanruikai$ ls
Java                            ReadCreditCardExcel.py          flow-platform-aggregator        nodejs                          resources
Mybatis-generator.iml           Test                            mygithub                        puhui-newapp-all                src
hanruikaideMacBook-Pro:eclipse-workspace hanruikai$ pwd
/Users/hanruikai/eclipse-workspace
hanruikaideMacBook-Pro:eclipse-workspace hanruikai$ py
pydoc               pydoc3              pyi-bindepend       pyi-set_version     python-config       python2.7           python3-config      python3.6m          pythonw2.6          pyvenv-3.6          
pydoc2.6            pydoc3.6            pyi-grab_version    pyinstaller         python2.6           python2.7-config    python3.6           python3.6m-config   pythonw2.7          
pydoc2.7            pyi-archive_viewer  pyi-makespec        python              python2.6-config    python3             python3.6-config    pythonw             pyvenv              
hanruikaideMacBook-Pro:eclipse-workspace hanruikai$ pyinstaller  ReadCreditCardExcel.py 
71 INFO: PyInstaller: 3.3.1
72 INFO: Python: 3.6.5
80 INFO: Platform: Darwin-16.7.0-x86_64-i386-64bit
81 INFO: wrote /Users/hanruikai/eclipse-workspace/ReadCreditCardExcel.spec
84 INFO: UPX is not available.
85 INFO: Extending PYTHONPATH with paths
['/Users/hanruikai/eclipse-workspace', '/Users/hanruikai/eclipse-workspace']
85 INFO: checking Analysis
85 INFO: Building Analysis because out00-Analysis.toc is non existent
85 INFO: Initializing module dependency graph...
87 INFO: Initializing module graph hooks...
88 INFO: Analyzing base_library.zip ...
3644 INFO: running Analysis out00-Analysis.toc
3655 INFO: Caching module hooks...
3658 INFO: Analyzing /Users/hanruikai/eclipse-workspace/ReadCreditCardExcel.py
4125 INFO: Loading module hooks...
4125 INFO: Loading module hook "hook-encodings.py"...
4207 INFO: Loading module hook "hook-pydoc.py"...
4208 INFO: Loading module hook "hook-xml.etree.cElementTree.py"...
4209 INFO: Loading module hook "hook-xml.py"...
4493 INFO: Looking for ctypes DLLs
4493 INFO: Analyzing run-time hooks ...
4501 INFO: Looking for dynamic libraries
4588 INFO: Looking for eggs
4588 INFO: Using Python library /Library/Frameworks/Python.framework/Versions/3.6/Python
4590 INFO: Warnings written to /Users/hanruikai/eclipse-workspace/build/ReadCreditCardExcel/warnReadCreditCardExcel.txt
4621 INFO: Graph cross-reference written to /Users/hanruikai/eclipse-workspace/build/ReadCreditCardExcel/xref-ReadCreditCardExcel.html
4638 INFO: checking PYZ
4638 INFO: Building PYZ because out00-PYZ.toc is non existent
4638 INFO: Building PYZ (ZlibArchive) /Users/hanruikai/eclipse-workspace/build/ReadCreditCardExcel/out00-PYZ.pyz
5023 INFO: Building PYZ (ZlibArchive) /Users/hanruikai/eclipse-workspace/build/ReadCreditCardExcel/out00-PYZ.pyz completed successfully.
5030 INFO: checking PKG
5030 INFO: Building PKG because out00-PKG.toc is non existent
5030 INFO: Building PKG (CArchive) out00-PKG.pkg
5038 INFO: Building PKG (CArchive) out00-PKG.pkg completed successfully.
5039 INFO: Bootloader /Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/PyInstaller/bootloader/Darwin-64bit/run
5039 INFO: checking EXE
5039 INFO: Building EXE because out00-EXE.toc is non existent
5039 INFO: Building EXE from out00-EXE.toc
5039 INFO: Appending archive to EXE /Users/hanruikai/eclipse-workspace/build/ReadCreditCardExcel/ReadCreditCardExcel
5041 INFO: Fixing EXE for code signing /Users/hanruikai/eclipse-workspace/build/ReadCreditCardExcel/ReadCreditCardExcel
5043 INFO: Building EXE from out00-EXE.toc completed successfully.
5044 INFO: checking COLLECT
5044 INFO: Building COLLECT because out00-COLLECT.toc is non existent
5044 INFO: Building COLLECT out00-COLLECT.toc
5529 INFO: Building COLLECT out00-COLLECT.toc completed successfully.