Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » CREATE EXCEL FILE FROM ORACLE (ORACLE FUSION MIDDLEWARE , XIN XP AND OFFICE 2007)
CREATE EXCEL FILE FROM ORACLE [message #450438] Wed, 07 April 2010 04:37
jihad
Messages: 4
Registered: May 2009
Junior Member
Dear ALL,

i m using oracle fusion middleware ,webutil , win xp and office 2007.

this function create an excel file in C:\MISOUT
Function F_Create_File ( p_FileName In Varchar2 ) Return Number Is
v_TxtFileID Text_Io.File_Type;
Begin
v_TxtFileID := Text_Io.FOpen(p_FileName,'w' );
If Text_IO.Is_Open(v_TxtFileID) Then Text_IO.FClose(v_TxtFileID); End If;
Return (1);
EXCEPTION WHEN OTHERS THEN
Return (-1);
End F_Create_File;

GOING TO WINDOWS C:\MISOUT I SEE THE FILE CREATED BUT WHEN I TRY TO OPEN IT A MESSAGE FROM MICROSOFT OFFICE EXCEL "EXCEL CANNOT OPEN THE FILE BECAUSE THE FILE FORMAT OR EXTENSION IS NOT VALID.VERIFY THAT THE FILE IS NOT CORRUPTEDAND THE EXTENSION MATCH THE FORMAT OF THE FILE"

THE EXTENSION IS XLSX AND IT IS RIGHT IN IN ORACLE
vFileName VARCHAR2(50):= GLOBAL_VAR.MISOUT ||
SUBSTR(:INVOICE,2,Cool ||'.xlsx ';


WHY I CANOT OPEN THE FILE , SO I CAN LATER LOAD DATA FROM ORACLE INTO THE FILE USING DDE.APP_BEGIN
thank you .
Previous Topic: shows old form to end users
Next Topic: DDE.Request in Oracle forms reading only 256 charactors correctly
Goto Forum:
  


Current Time: Tue Oct 21 22:46:56 CDT 2014

Total time taken to generate the page: 0.13410 seconds