def export_trait_excel():
"""Excel file consisting of the sample data from the trait data and analysis page"""
print("In export_trait_excel")
print("request.form:", request.form)
sample_data = export_trait_data.export_sample_table(request.form)
print("sample_data - type: %s -- size: %s" %
(type(sample_data), len(sample_data)))
buff = StringIO.StringIO()
workbook = xlsxwriter.Workbook(buff, {'in_memory': True})
worksheet = workbook.add_worksheet()
for i, row in enumerate(sample_data):
worksheet.write(i, 0, row[0])
worksheet.write(i, 1, row[1])
if len(row) > 2:
worksheet.write(i, 2, row[2])
workbook.close()
excel_data = buff.getvalue()
buff.close()
return Response(excel_data,
mimetype='application/vnd.ms-excel',
headers={
"Content-Disposition":
"attachment;filename=sample_data.xlsx"
})
def export_trait_excel():
"""Excel file consisting of the sample data from the trait data and analysis page"""
logger.info("In export_trait_excel")
logger.info("request.form:", request.form)
logger.info(request.url)
trait_name, sample_data = export_trait_data.export_sample_table(
request.form)
logger.info("sample_data - type: %s -- size: %s" %
(type(sample_data), len(sample_data)))
buff = io.BytesIO()
workbook = xlsxwriter.Workbook(buff, {'in_memory': True})
worksheet = workbook.add_worksheet()
for i, row in enumerate(sample_data):
for j, column in enumerate(row):
worksheet.write(i, j, row[j])
workbook.close()
excel_data = buff.getvalue()
buff.close()
return Response(excel_data,
mimetype='application/vnd.ms-excel',
headers={
"Content-Disposition":
"attachment;filename=" + trait_name + ".xlsx"
})
def export_trait_csv():
"""CSV file consisting of the sample data from the trait data and analysis page"""
print("In export_trait_csv")
print("request.form:", request.form)
sample_data = export_trait_data.export_sample_table(request.form)
print("sample_data - type: %s -- size: %s" % (type(sample_data), len(sample_data)))
buff = StringIO.StringIO()
writer = csv.writer(buff)
for row in sample_data:
writer.writerow(row)
csv_data = buff.getvalue()
buff.close()
return Response(csv_data,
mimetype='text/csv',
headers={"Content-Disposition":"attachment;filename=test.csv"})
def export_trait_csv():
"""CSV file consisting of the sample data from the trait data and analysis page"""
logger.info("In export_trait_csv")
logger.info("request.form:", request.form)
logger.error(request.url)
sample_data = export_trait_data.export_sample_table(request.form)
logger.info("sample_data - type: %s -- size: %s" % (type(sample_data), len(sample_data)))
buff = StringIO.StringIO()
writer = csv.writer(buff)
for row in sample_data:
writer.writerow(row)
csv_data = buff.getvalue()
buff.close()
return Response(csv_data,
mimetype='text/csv',
headers={"Content-Disposition":"attachment;filename=sample_data.csv"})
def export_trait_excel():
"""Excel file consisting of the sample data from the trait data and analysis page"""
print("In export_trait_excel")
print("request.form:", request.form)
sample_data = export_trait_data.export_sample_table(request.form)
print("sample_data - type: %s -- size: %s" % (type(sample_data), len(sample_data)))
buff = StringIO.StringIO()
workbook = xlsxwriter.Workbook(buff, {'in_memory': True})
worksheet = workbook.add_worksheet()
for i, row in enumerate(sample_data):
worksheet.write(i, 0, row[0])
worksheet.write(i, 1, row[1])
workbook.close()
excel_data = buff.getvalue()
buff.close()
return Response(excel_data,
mimetype='application/vnd.ms-excel',
headers={"Content-Disposition":"attachment;filename=test.xlsx"})
