Friday, December 27, 2013

Oracle Application XML Reports in EXCEL



1. Create new Viewer Option
Navigate to System Administrator àInstall àViewer Options.
Add a new entry.

File Format                                         : XML
Mime Type                                         : application/vnd.ms-excel
Description                                         : XML in Microsoft Excel
Allow Native Client Encoding          : Yes(Enable)

2. Set Profile Options
Set profile àViewer: Text to Browser
Set profile àViewer: Application to XML in Microsoft Excel

3.Submit a Concurrent Request that generates Text Output File
Click on View Output
Button
You will see a LOV showing
--> Microsoft Word(.doc)
--> Excel (.xls)
--> Notepad(.txt)

When you choose Microsoft Word(.doc) , the Text File will be transferred using the Mime Type application/msword then the browser will open the Text File in Word

When you choose Excel (.xls) , the Text File will be transferred using the Mime Type application/vnd.ms-excel then the browser will open the Text File in Excel

When you choose Notepad(.txt) , the Text File will be transferred using the Mime Type text/plain then the browser will open the Text File in Notepad

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect