Hi team,
I am consuming a rest service that sends me the binary response of an excel file(create on server). But, when I am passing the binary response to the Download widget of Service Studio with proper mime type as
Excel Mime Type
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
It gets download well in desktop but not in Ipad. It shows white blank screen on Ipad. Also, to test whether Ipad is working fine with excel i did a test by passing some dummy data to native RecordListToexcel and download. It was working fine but not with API binary response.
Kilian Hekhuis wrote:
Well, downloading files on iOS is always a problem. See for example this article for more information.
I investigated the issue and found that the Rest API is using OpenXML library to generate excel binary. There are issues associated with OpenXML on generating excel file for Ipad/Mac versions(source).
Even I tried to replicate the same issue in Visual Studio and found that excel generated with OpenXML using .Net Dataset objects are causing issues in IPAD. I used EPPlus library and it worked just fine.
I think it's clear that it is not related with Outsystems rather than excel library and ipad.
Hi Arj,
This is a web app you are opening on the iPad? Do you have an app on the iPad that can open a xlsx?
This is a website I am opening in iPAD Safari. I already have app that can open the xlsx. But the excel file generated from Rest API is not getting opened in IPAD(in all browsers) but gets open in desktop.
What you could do:
Make sure the web screen layout is empty, so if you tried to navigate it empty.
Thanks for the follow-up! I'll mark your latest reply as Solution.