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