Yes that helps, what I was really missing was the simple idea that you are using the Office Online viewer, so I just reference that:: https://view.officeapps.live.com/op/view.aspx?src={}
Note that you have to escape out the URL for the source, I am sure you do that in the above suggestion.
thanks for the response.
Hi, I am using the hosted API and trying to show an Excel report in the browser. It works great in the studio.
When I try to use it via the API, it just downloads the Excel file and doesn't show it in Excel Online. I am sure I am just missing something...
I am using Python (django), here is a snippet of how I return the data:
report = requests.post(url, data=body, headers=headers, auth=auth)
response = HttpResponse(report)
response['Content-type'] = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
return response
I can get PDF's to work great by changing the content-type to 'application/pdf'
Should I have a wrapper or something around the Excel data to preview it online?