如何运行xlrd-0.9.3

Question

当我运行这个python文件时，我在控制台中得到一个错误:文件"Documents/test.py"，第4行xlrd-0.9.3\xlrd\ ^ SyntaxError:无效语法

如何加载xlrd包？我从这里下载了这个包：http://www.python-excel.org/

注意:我下载的xlrd-0.9.3文件夹与这个.py文件在同一级别：

import urllib
xlrd-0.9.3\xlrd\
import xlrd

url = "http://us.spindices.com/idsexport/file.xls?hostIdentifier=48190c8c-42c4-46af-8d1a-0cd5db894797&selectedModule=PerformanceGraphView&selectedSubModule=Graph&yearFlag=all&indexId=10001901"

urllib.urlretrieve(url, "test1.xls")


rb = xlrd.open_workbook('test1.xls',formatting_info=True)
sheet = rb.sheet_by_index(0)
for rownum in range(sheet.nrows):
row = sheet.row_values(rownum)
for c_el in row:
    print c_el

Answer 1

试用xlrd包：

import xlrd
rb = xlrd.open_workbook('document.xls',formatting_info=True)
sheet = rb.sheet_by_index(0)
for rownum in range(sheet.nrows):
    row = sheet.row_values(rownum)
    for c_el in row:
        print c_el