def parse_upload_form():
f = request.files.get('file')
data = []
if f and allowed_file(f.filename):
extension = str(f.filename.rsplit('.', 1)[1].lower())
if extension == "xlsx" or extension == "xls":
workbook = xlrd.open_workbook(file_contents=f.read())
worksheet = workbook.sheet_by_index(0)
data = list(utils.cast_row(worksheet.row_values(rx, 0, 3)) for rx in range(worksheet.nrows) if worksheet.row_len(rx) == 3)
elif extension == "csv":
data = utils.data_from_csv_string(f.read().decode("utf-8"))
else:
csv = request.form['data']
data = utils.data_from_csv_string(csv)
return data
def parse_upload_form():
f = request.files['file']
data = []
if f and allowed_file(f.filename):
extension = str(f.filename.rsplit('.', 1)[1].lower())
if extension == "xlsx" or extension == "xls":
workbook = xlrd.open_workbook(file_contents=f.read())
worksheet = workbook.sheet_by_index(0)
data = list(utils.cast_row(worksheet.row_values(rx, 0, 3)) for rx in range(worksheet.nrows) if worksheet.row_len(rx) == 3)
elif extension == "csv":
data = utils.data_from_csv_string(f.read().decode("utf-8"))
else:
csv = request.form['data']
data = utils.data_from_csv_string(csv)
return data