Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

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

Posted on November 14th, 2008 by Sanjit Anand |Print This Post Print This Post |Email 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

file-export

Fig 1

2. Check out for TSV File format , if not exist , create a new type by Pressing NEW button.

2

Fig 2

3. Now you need to setup default to excel, go to change Button in fig 2, and point to Microsoft Excel

3

Fig 3

Related Posts

Posted in AOL | 8 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
8 Responses
  1. Jimmy Says:

    yeah, it’s nice.

    thanks for your sharing.

  2. jimmy Says:

    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. Sanjit Anand Says:

    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. Manohar Says:

    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. Jimmy Says:

    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. Mark Tash Says:

    Any idea how this can be set in vista/64

  7. User Unable to Export Data to TSV File | OracleApps Epicenter Says:

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

  8. HLA Says:

    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

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.