如何用python将二进制excel数据读取出来？：报错

将execl表格导出为csv格式，然后数据就是一行一行以逗号分割的数据。后面就好办了吧######找python的excel库。
######

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

多看看文档有益身心健康

file_contents... as a string or an mmap.mmap object or some other behave-alike object. If file_contents is supplied, filename will not be used, except (possibly) in messages.

import pandas as pd

data=pd.read_excel(file_excel)

import xlrd

data = xlrd.open_work(filedata)

table = data.sheets()[0]

col_1 = table.col_values(0)

col_2 = table.col_values(1)

...

xlrd.open_workbook()是不行的，该函数直接将filedata作为文件全名来处理的;