|Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today|
Oracle Applications allows you to export data that you see on the form to a file - like excel - which can be then be used as a normal excel file. These are really useful when you want a quick dump of the data for reference or are trying to trouble-shoot some issue.
The File - Export option allows you to dump the data you see on the form (or data set you have queried).
The default is a file type called "tsv", that means tab separated values and can be opened by default in Notepad in most cases, but can also be configured to open in Excel, which is a choice for most of user.
Problem : How Can you do a Setup File->Export as an XLS Type File default?
Here are the steps
1. Go to Explore(not IE) ->Tool -> Folder Options
2. Check out for TSV File format , if not exist , create a new type by Pressing NEW button.
3. Now you need to setup default to excel, go to change Button in fig 2, and point to Microsoft Excel