Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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;

  • #2
    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-
    Attached Files
    Let's connect on LinkedIn
    Mobile: +91 973 049 6886
    E-mail: [email protected]

    If my post was helpful, then click on the Like button

    Comment

    Working...
    X