Posted on November 14th, 2008 by Sanjit Anand |
Print This Post
|
Email This Post
| 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
Fig 1
2. Check out for TSV File format , if not exist , create a new type by Pressing NEW button.
Fig 2
3. Now you need to setup default to excel, go to change Button in fig 2, and point to Microsoft Excel
Fig 3
Related Posts
November 24th, 2008 at 5:39 am
yeah, it’s nice.
thanks for your sharing.
November 24th, 2008 at 6:28 pm
hello,Sanjit,
I have tried your method in my environments,my environment has chinese char,so, it displays mess code in excel. do you have any idea about this.
November 24th, 2008 at 8:46 pm
Hi Jimmy,
this setup was for defualting the file extension.
What is meant by chinese char. i believe this is inside the data. Then you need to make sure about font compatiblity of desktop/laptop OS plus MS Office Font.
Could you please elaborate more in the issue.
regards
sanjit
November 27th, 2008 at 1:45 am
Hi Jimmy,
I thing your problem can be solve in this way.
Step1: save the export file in .tsv formate.
Step2: open the tsv file and select all then past in a Excle sheet.
Hi
Sanjit,
Please correct me if i am wrong.
Best regards
Manohar
November 27th, 2008 at 6:45 am
hi,Sanjit&Manohar
thanks Manohar, if I save as the tsv file and select the char: unicode. And then I open it in the excel, it would work well. But if I want to do like addressing in this article, It would display mess code in the excel.
Anyway, thanks for your sharing.
December 18th, 2008 at 10:14 am
Any idea how this can be set in vista/64
January 23rd, 2009 at 11:16 pm
[...] Setting default to Excel for Exported file from “File ->Export “ [...]
February 23rd, 2010 at 9:14 am
Hi Sanjit Anand,
I’m using an OA 11.0.3 version, i have tried to export a PO data from OA to an xls file, but system generated this error:
SECURITY-FAILED TO CONNECT (FNDNAM=APPS) (GWYUID=APPLSYSPUB/PUB@VIS) (TWO_TASK=VIS)(GUEST_USER_PWD=GUEST/GUEST1)
Could you help me to resolve this problem.
Thanks
HLA