I'm using APEX 4.0.1 and I'm trying to download an Interactive Report to excel.
The download works without any errors, but the file contains only the header of the columns and the rest of the file is empty!
I get the same result when I try to download to pdf or rtf.
When I started the application, downloading to excel worked fine, but since then I don't know what I've done to change the behaviour.
I can't use the csv format, since I have Hebrew in the database and the character translation to windows doesn't work well,
As far as i know exporting to excel is the same as exporting to csv.. Have you ever succeeding in exporting non-Latin (in your case Hebrew) to csv and worked ?
I am trying to do the same for Greek characters, but no success. The only case i succeed in using apex.oracle.com...
Does it work if you export in HTML? I succeed in HTML export only, so if this fits in your needs then you may get by...
Can you try apex.oracle.com and see if you put Hebrew characters there if it works ?
I managed to export to csv file correctly.
What you need to do for that is go to Shared components -> Globalization Attributes -> and change Application Primary Language to your language
also change the "Automatic CSV Encoding" to Yes.
After doing that the csv file is generated correctly.
Hope that it helps...