- OracleApps Epicenter - http://www.oracleappshub.com -

Setting default to Excel for Exported file from “File ->Export “

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

8 Comments (Open | Close)

8 Comments To "Setting default to Excel for Exported file from “File ->Export “"

#1 Comment By Jimmy On November 24, 2008 @ 5:39 am

yeah, it’s nice.

thanks for your sharing.

#2 Comment By jimmy On November 24, 2008 @ 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.

#3 Comment By Sanjit Anand On November 24, 2008 @ 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

#4 Comment By Manohar On November 27, 2008 @ 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

#5 Comment By Jimmy On November 27, 2008 @ 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.

#6 Comment By Mark Tash On December 18, 2008 @ 10:14 am

Any idea how this can be set in vista/64

#7 Pingback By User Unable to Export Data to TSV File | OracleApps Epicenter On January 23, 2009 @ 11:16 pm

[…] Setting default to Excel for Exported file from “File ->Export “ […]

#8 Comment By HLA On February 23, 2010 @ 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