Anton Scheffer

Here is some code you can use for reading xlsx files. Free to use for everyone, without a license. If you want I have code for reading the older xls...

You could use something like: `` create or replace package as_source is subtype tp_all_source_row is sys.all_source%rowtype; type tp_all_source_tab is table of tp_all_source_row; function get_source ( object_name varchar2 , object_type varchar2...

You already have that permission, see https://github.com/OraOpenSource/oos-utils/issues/112

To quote from the [usage.md](https://github.com/antonscheffer/as_sftp/blob/master/usage.md) > As soon as I think that this package is used (lots of stars, lots of bug issues, lots of feature requests, lots of donations)...

The error "PLS-00201: identifier 'EXCEL2COLLECTION.TP_SHEETS' " is something you can ignore. The second error "ORA-06502: PL/SQL: numeric or value error" is more serious. That means it can not parse the...

You could try that XLS-file at my demo application for this plugin at [Demo application for EXCEL2COLLECTION](https://apex.oracle.com/pls/apex/f?p=33308) That application uses the "package-parser" which, besides being much faster, provides more logging...

I removed the code to try using "a" package.

Could you share that Excel? With dummy values in the mail id column would be fine.

I've found the problem with the date issue. It is already in the demo at https://apex.oracle.com/pls/apex/f?p=33308. I hope to have some spare time this weekend to update the plugin version...

@grlicaa The reason for the change of the parameters to text. The Yes/No attribute can not be based on a Page Item, it is only a slider checkbox in the...