Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problems Exporting to excel

Gui Rocha-OracleMar 18 2015 — edited Mar 18 2015

Hi everyone,

I`m trying to export my interactive report to a excel file.

In the attributes of my interactive report  i check the pdf, excel and csv options to be downloadable.

The problem is, only the csv file works ( and barely since it doesn t come separated by columns, even with  the rules to automatically separate them in apex are checked - but this is ok, i can change them in excel)

The real issue is when i try to open the pdf or xls files they return me errors. the pdf file doesn`t even open and the excel gives me an error

" The file you are trying to open is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?""

(i tried a solution i find in one of the posts here to edit regedit but it was a solution for excel 2007, even tough mine is 2010, and it didn`t work) and after i close the error message excel opens with the following message " ORA-06502: PL/SQL: numeric or value error: character string buffer too small"

Does anyone knows how to fix this

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2015
Added on Mar 18 2015
1 comment
1,234 views