I need package for excel or anybody that can help me

[idran]

I found an example on how read range of value from excel on forms HELP.....but they use a package that can't find anywhere......anybody can help me or say where can I find a similar package.....
the example that found is:
It's not normal give an example and don't give the package script. And on this topic there are only example and not explication.
If anybody can help me, I'm happy.


Example 2
/*
Get the value of a range of cells in Microsoft Excel for populating a PL/SQL table. The PL/SQL table can be used as a block data source.
*/

DECLARE
TYPE myrec IS RECORD (
x varchar2(10),
y varchar2(10),
z varchar2(10));

TYPE mytable is TABLE OF myrec
INDEX BY BINARY_INTEGER;

TableXYZ mytable;
Range OleVar;
Value OleVar;



BEGIN
/* Find the range of cells you want to interact with */
Range := EXCEL_WORKSHEET.ole_Range(
:CTRL.interface,
To_Variant('A1:C3'));

/* Get the value of cells in the range from A1 to C3 */
Value := EXCEL_RANGE.Value(Var_tbj(Range));

/* Populate PL/SQL Table; can access cell values using PL/SQL Syntax such as TableXYZ(1).x, TableXYZ(1).y, TableXYZ(2).x, TableXYZ(2).y, etc. */
Var_to_Table(Value,TableXYZ);
END;

 

[taupirho]

Idran, point your browser over to my website at

http://the-big-o.port5.com

and you'll see a couple of articles explaining various ways of getting data to/from excel and Oracle

 

[idran]

OK....but I have to use pl/sql not VB....