How to read uploaded excel file in postman?

Asked May 25 '18 at 11:13

Active May 25 '18 at 11:13

Viewed 28 times

I tried to read and analyze text in excel file in postman. Here is mycode. import pandas as pd from flask import request,jsonify,Flask

import pandas as pd
from flask import request,jsonify,Flask

app = Flask(__name__)
@app.route('/upload', methods=['POST'])

def excel():
    data=request.files()
    df=pd.read_excel(data)
    textdf=df['Text']
    Text=[]
    for i in range(len(textdf)):
        Text.append(textdf[i])

    return jsonify({"Data":Text[0]})
if __name__ == '__main__':
    app.run(host= '0.0.0.0',debug=False,port=17002)

and I got this error.

TypeError: 'ImmutableMultiDict' object is not callable

asked May 25 '18 at 11:13

SupLike RealLife

1

data = request.files['file'], and then use postman post to send a file name with exact this key. I think it should work. – NoorJafri May 25 '18 at 11:41
It works. Thank you so much. If i want to know more about this, could you tell me the keyword to search in google? – SupLike RealLife May 26 '18 at 06:37
I made this gist for someone: https://gist.github.com/nurely/68cb7cf6bfc2da881004d070c536f258 – NoorJafri May 26 '18 at 06:40

How to read uploaded excel file in postman?

0 Answers0