""" Basic file upload example for Flask
Example provided for spitfiredd on thread
https://www.reddit.com/r/flask/comments/5zen73/help_looking_to_create_a_simple_web_app_where_i/?ref=share&ref_source=link
"""
from flask import Flask, request, render_template, send_file
app = Flask(__name__)
# We need a secret key to work with form data
# http://flask.pocoo.org/docs/0.12/config/#builtin-configuration-values
app.config['SECRET_KEY'] = 'super secret'
@app.route('/', methods=['GET', 'POST'])
def index():
# The browser sends an HTTP GET when opening a page
# so we respond with some HTML to display our page
if request.method == 'GET':
return '''
Upload
'''
elif request.method == 'POST':
# Get our files from the request object (or None if
# there is no file
file1 = request.files.get('file1', None)
file2 = request.files.get('file2', None)
# Check if files exist
files_exist = file1 != None and file2 != None
files_name = file1.filename != '' and file2.filename != ''
# Return error if they don't
if not (files_exist and files_named):
flash('Please select two files')
return redirect(request.url)
# Do processing here (e.g. load into pandas)
#
# NOTE: If you are saving the files with the original name
# make sure to sanitize it first
#
# Example (http://xlsxwriter.readthedocs.io/working_with_pandas.html#saving-the-dataframe-output-to-a-string):
import io
import pandas as pd
d = pd.DataFrame()
output = io.BytesIO()
writer = pd.ExcelWriter(output, engine='xslxwriter')
d.to_excel(writer, sheet_name='Sheet1')
writer.save()
return send_file(output, attachment_filename='output.xslx', as_attachment=True)