Pyexcel从excel上传获取记录

Question

我正在尝试将pyexcel集成到Django项目中，并试图遵循文档上的示例。

我试图复制这个功能：

import pyexcel as pe
records = pe.iget_records(file_name="your_file.xls")
for record in records:
    print("%s is aged at %d" % (record['Name'], record['Age']))

如何通过文件上传打开记录。我试过这么做却没有运气：

if request.method == "POST":
    form = UploadFileForm(request.POST, request.FILES)
    records = pe.iget_records(file_name=request.FILES['file'])
    for record in records:
    ..

这一行是错误的: records = pe.iget_records(file_name=request.FILES['file'])

编辑：似乎发生在for循环中，并且是：

IOError: Wrong file name

Answer 1

文档中有一个记录。

if request.method == "POST":
    form = UploadFileForm(request.POST, request.FILES)
    records = request.FILES['file'].get_records()
    for record in records:
    ..

如果坚持使用iget_record，可以尝试：

if request.method == "POST":
    form = UploadFileForm(request.POST, request.FILES)
    file = request.FILES['file']
    file_type = file.name.split('.')[-1]
    records = pe.iget_records(file_stream=file, file_type=file_type)
    for record in records:
    ..