Forum Stats

  • 3,874,088 Users
  • 2,266,676 Discussions
  • 7,911,721 Comments

Discussions

How to create Excel file

Vivek More
Vivek More Member Posts: 14
edited Jan 15, 2010 7:28AM in SQL & PL/SQL
Hello All,

I want to generate excel file from Oracle 11g in Linux REDHAT 5 environment.

I know, it can be done by using ORDCOM, ORDExcel packages available in ORACLE_BASE/ORACLE_HOME/com directory in Mircrosoft Windows environment.

But, the folder ORACLE_BASE/ORACLE_HOME/com not found.

How to proceed ?

Please help me out. This is very urgent.

Thank you in advance.
Tagged:
«1

Answers

  • Pierre Forstmann
    Pierre Forstmann Member Posts: 6,961 Silver Crown
    If you only need to unload data in CSV format, please have a look to http://tkyte.blogspot.com/2009/10/httpasktomoraclecomtkyteflat.html
  • BluShadow
    BluShadow Member, Moderator Posts: 42,555 Red Diamond
    Vivek More wrote:

    How to proceed ?

    Please help me out. This is very urgent.
    Urgent is it? Why?

    What makes you believe that your request for help is more important than someone else who has requested help? It's very rude to assume you are more important than somebody else, and I'm sure they would like an answer to their issue as soon as they can get one too, but they've generally been polite and not demanded that it is urgent.

    Also, you assume that people giving answers are all sitting here just waiting to answer your question for you. That's not so. We're all volunteers with our own jobs to do. How dare you presume to demand our attention with urgency.

    If you want help and you want it answering quickly you simply just put your issue forward and provide as much valuable information as possible.

    Looking at your post you haven't told us what database version you are using and you haven't even shown us that you've had a go at doing something yourself.

    You will find if you post on here demanding your post is urgent then most people will just ignore it, some will tell you to get lost, and some will explain to you why you shouldn't post "urgent" requests.


    In answer to your question though,
    I want to generate excel file from Oracle 11g in Linux REDHAT 5 environment.

    I know, it can be done by using ORDCOM, ORDExcel packages available in ORACLE_BASE/ORACLE_HOME/com directory in Mircrosoft Windows environment.

    But, the folder ORACLE_BASE/ORACLE_HOME/com not found.
    Oracle does not provide any standard Excel output methods. Not sure where you got this information from.

    if you want multiple sheets created you would need to use something like Office XML format for your output data. Take a look at the following links for more information about doing that...

    http://support.microsoft.com/kb/288215
    http://blogs.msdn.com/brian_jones/archive/2005/06/27/433152.aspx
    2516584
  • 730428
    730428 Member Posts: 2,087 Gold Trophy
    edited Jan 15, 2010 3:30AM
    You can create excel files using [Microsoft Office 2003 XML Formats|http://en.wikipedia.org/wiki/Microsoft_Office_2003_XML_formats].

    Here's a post on my blog that explains how to do it, the post is in Italian, but I think you can give a look to the queries...

    Max
    [My Italian Oracle blog|http://oracleitalia.wordpress.com/2010/01/10/crittografia-in-plsql-utilizzando-dbms_crypto/]
  • Vivek More
    Vivek More Member Posts: 14
    Dear Sir,

    I am extremly sorry. Sure, from now I will simply post my query/problem.

    I will come with more information. The following link is just for your information.

    http://www.adp-gmbh.ch/ora/com/index.html


    Once again sorry.

    Thank you for your prompt reply.
  • BluShadow
    BluShadow Member, Moderator Posts: 42,555 Red Diamond
    Vivek More wrote:
    Dear Sir,

    I am extremly sorry. Sure, from now I will simply post my query/problem.

    I will come with more information. The following link is just for your information.

    http://www.adp-gmbh.ch/ora/com/index.html
    I never used COM automation before myself as there always seemed to be easier ways.

    However:

    http://www.oracle.com/technology/tech/windows/com_auto/index.html

    Looks like it's an old 8i and 9i feature. Not even sure it exists anymore in 10g onwards. I certainly don't have it in my own installation.
  • Marwim
    Marwim Member Posts: 3,654 Gold Trophy
    Hello Vivek,

    have you tried to search this forum? Creating Excel files is a question that is asked at least once a week.

    https://xml-spreadsheet.samplecode.oracle.com/ or
    https://exceldocumenttype.samplecode.oracle.com/
    Others can be found at 2516584

    Regards
    Marcus
    Marwim
  • Vivek More
    Vivek More Member Posts: 14
    Sir,

    It is there in Oracle 11g. I am using it on Windows platform.

    The problem is, Now I want to use the same on Linux REDHAT 5 platform. And there is no com folder present in /oracle_base/oracle_home

    Using the COM automation, we can give the file name and location dynamically. So it is very convinient.

    Thank You.
  • Vivek More
    Vivek More Member Posts: 14
    Hi Marcus,

    It is helpful.

    Thanks for your reply.
  • BluShadow
    BluShadow Member, Moderator Posts: 42,555 Red Diamond
    Vivek More wrote:
    Sir,

    It is there in Oracle 11g. I am using it on Windows platform.

    The problem is, Now I want to use the same on Linux REDHAT 5 platform. And there is no com folder present in /oracle_base/oracle_home
    Ah, I missed that bit. Of course there won't be COM automation in any *nix flavour of operating system. COM automation is specific to Windows. How do you expect your Linux server to talk to Excel when Excel is a windows based product and won't be installed on your operating system.
  • Vivek More
    Vivek More Member Posts: 14
    Sir,

    You are absolutely right. This is my exact problem.

    But how could Oracle develop features like COM automation with specific to one operating system like Windows?

    Sure, there would be solution for this. Because, in Linux there is Openoffice, openexcel. so Linux server can talk to Openexcel.

    Could you please let me know, if you find any information ?

    Thanks.
This discussion has been closed.