Hi
I am looking at Anton Scheffer procedure to query an excel file
select * from table( as_read_xlsx.read( as_read_xlsx.file2blob( 'DOC', 'Book1.xlsx' ) ) );
Once I get the results, how do I get these into a table
For example
select row_nr, col_nr, string_val, number_val, date_val from table( as_read_xlsx.read( as_read_xlsx.file2blob( 'DOC', 'angus_test.xlsx' ) ) )
where row_nr > 1
and sheet_nr = 2
order by row_nr, col_nr;
Returns
My table is
CREATE TABLE XXX_DDD
( PERSON_NAME VARCHAR2(1000 CHAR),
EMP_NO NUMBER,
DOB DATE,
SAL NUMBER,
COMM NUMBER)
Regards
Gus