Oracle report export to excel o/p not of excel type

[hi.shekhu2002]

Hi,

I have created a report and have given export to excel link. When i click on export to excel an output file is generated. The issue is the output file is not of type excel file. Though when i save the output and open it with excel the o/p comes correctly in excel with correct headers and data.I have used.

I have used the below entry in the after p form for excel hyperlink where _date_from is the user parameter.

_excel_hyperlink := _report_call||'?'||_rep_userid||'&server='||_reports_server|| '&report='||_report_physical_name||'_excel&destype=CACHE&desfo rmat=DELIMITED&mimetype=applicaion/vnd.ms-excel&p_gl_user='||_GL_USER||'&p_within_report=Y'
||'&p_rep_userid='||_rep_userid||'&P_DATE_FROM='||_date_from;

[Prasad Chandane]

Re: Oracle report export to excel o/p not of excel type

Hi,

Generally, when we extract report from OTM in Excel format then, we get one warning, attached is the sample screensnap for the same

You just need to press on 'Yes' and save Excel file in '.xlsx' format

While generating report in Excel format - OTM by default populate data in HTML format and hence the size of report is large than normal Excel file

Thank you


-Prasad-