Problems Exporting to excel

Gui Rocha-Oracle

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

TexasApexDeveloper

To export to an Excel style file you need to have a print engine that supports doing this.  DO you have BI Publisher installed and configured with your APEX instance?  If not, there are plugins available to allow you to download you report to a XLSX style file:http://glebovpavel.github.io/Description_IR_TO_XSLX/.

Thank you,

Tony Miller
LuvMuffin Software
Ruckersville, VA