How to create Excel file

Vivek More

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.

Pierre Forstmann

If you only need to unload data in CSV format, please have a look to http://tkyte.blogspot.com/2009/10/httpasktomoraclecomtkyteflat.html

BluShadow

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

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

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

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

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

Vivek More

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

Hi Marcus,

It is helpful.

Thanks for your reply.

BluShadow

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

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.