ORA_EXCEL

[Kalyan Ganesan]

Can anyone tell me what all i need to create a procedure to export data to Excel...i tried using ORA_EXCEL but its giving me error

When i try something like this below

PROCEDURE'

BEGIN
ORA_EXCEL.new_document;
ORA_EXCEL.add_sheet('My Sheet');
ORA_EXCEL.add_row;
ORA_EXCEL.set_cell_value('A', 'Hello World!');
ORA_EXCEL.save_to_file('C:\EXPORT_DIR', 'example.xlsx');
END;


i get an error in the very first line ORA_EXCEL.new_document;

 

[fredericofonseca]

Ora_excel is a paid for product (

https://www.oraexcel.com/)

that you have to install on your Oracle instance - did you check it is available on your server?

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[Kalyan Ganesan]

How do i find if (ORA_EXCEL) it is installed?

 

[Andrzejek]

You can execute the following query:
[tt]
SELECT * FROM dba_source WHERE UPPER(name) = 'ORA_EXCEL';[/tt]
or[tt]
SELECT * FROM dba_source WHERE UPPER(text) LIKE '%ORA_EXCEL%';
[/tt]
If it returns any rows, then you have ORA_EXCEL installed in a schema from the "OWNER" column.


Have fun.

---- Andy

There is a great need for a sarcasm font.

 

[Kalyan Ganesan]

Yea i ran the queries it didnt return any row..so i understand i need to install it..so its a paid product isnt it?

 

[Andrzejek]

Yes, pricing is here

Have fun.

---- Andy

There is a great need for a sarcasm font.

 

[Beilstwh]

If you want a free package that will create excel spreadsheets see the following link. It is not as polished as ORA_EXCEL but works very nicely.

https://technology.amis.nl/2011/02/19/create-an-excel-file-with-plsql/

Bill
Lead Application Developer
New York State, USA