Sharing pandas dataframe as xlsx files without (too) much trouble. Using xlsxwriter from http://xlsxwriter.readthedocs.io/working_with_pandas.html

gistfile1.txt

import numpy as np
import pandas as pd

import StringIO

def testExport(request):
	# creating a dataframe and doing stuff about it
	testDataframe = pd.DataFrame(np.random.randn(1,4), columns=list('ABCD'))
	
	# generate output
	output = StringIO.StringIO()
	writer = pd.ExcelWriter(output, engine='xlsxwriter')
	testDataframe.to_excel(writer)
	writer.save()
	writer.close()
	
	# now, sending the dataframe to the user
	output.seek(0)
	response = HttpResponse(output.read(),content_type='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')
	response['Content-Disposition'] = 'attachment; filename="testDataframe.xlsx"'
	
return response