Forum Stats

  • 3,837,812 Users
  • 2,262,300 Discussions
  • 7,900,398 Comments

Discussions

Problems Exporting to excel

Gui Rocha-Oracle
Gui Rocha-Oracle Member Posts: 18 Employee
edited Mar 18, 2015 9:17AM in APEX Discussions

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

Tagged:

Answers

This discussion has been closed.