THEN attach the PLL to the form and IN THE MAIN PROCEDURE in the form:

declare
p_value number := 4;
begin
EXCEL.open_excel;
EXCEL.open_workbook;
EXCEL.open_excel_doc('c:\a.xls');
EXCEL.activate_sheet(1); -- 1 is the first worksheet from left
EXCEL.READ_NUM_CELL(1, 1, p_value);
-- do what is needed with the p_value
EXCEL.close_excel_doc;
EXCEL.close_workbook;
EXCEL.close_excel;
end;

0

klm11204Commented: 2008-09-23

Hello,
I need a pure pl/sal code that can read from xls sheet as table i want to update 5 oracle tables from
this excel sheet
question do you to load this xls sheet to a templ table and do my business logic on it?
or can i deal with excel sheet as an oracle table ie reading from it using sql statment?
is this doable?
please help how i can do that?