TypeError: invalid file: None about flask-excel HOT 7 CLOSED

https://github.com/pyexcel/pyexcel-webio/blob/master/pyexcel_webio/__init__.py#L197 returns:

{'file_content': b'', 'name_columns_by_row': 0, 'file_type': 'xlsx'}

Hence, it means request.files['file'].read() == "", empty file was uploaded.

Here's how I upload a file programmatically https://github.com/pyexcel/Flask-Excel/blob/master/tests/test_upload_n_download_excel.py#L36

Here's how I upload file using html form https://github.com/pyexcel/Flask-Excel/blob/master/examples/tiny_example.py#L19

from flask-excel.

And what you can test is:

@pre_save(sender=BulkMessage)
def on_bulk_message_save_handler(model_class, instance, created):
    import pdb;pdb.set_trace()
    print(request.files['file'].read())
    instance.file_fields = request.get_array(field_name='file')

from flask-excel.

Yeah, the strange thing is that the file is in fact uploaded every time.

And it looks correct here in the request:

>>> request.files
ImmutableMultiDict([('file', <FileStorage: 'SMS_dummy_data.xlsx' ('application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')>)])

But it's true that I can't read() it:

>>> print(request.files['file'].read())                                              
b''

But why is it correctly uploaded then? I'm sure this is some basic Flask noob mistake. Probably not anything wrong with your library.

from flask-excel.

Oh yeah, the tiny example works perfectly.

from flask-excel.

Just in case we may have skipped this line:

<form .. enctype=multipart/form-data>

according to Flask documentation

from flask-excel.

That line is generated by the FileUploadField from Flask-Admin. And I do in fact see the file contents in the request in Firefox' inspector. And it does get uploaded. Really weird,

from flask-excel.

It was found in pyexcel/pyexcel#67 that the upload file stream could have been consumed. Maybe a file.seek(0) could help.

from flask-excel.