Upload an Excel file into an Apex Collection Using Plugins

1. Download Excel2Collection plugins sql file
2. Create a page and a Region for uploading Excel file with a FILE BROWSE item
   and a button for UPLOAD. Choose SQL insert action as Database Action.
3. Create a another Region for showing uploaded excel report as CLASSIC REPORT.
   The SQL will be like :     Select * from apex_collections ;
 
4. Now create a PROCESS for the taking the PLUGIN as type Excel2Collection(Plugin).
   Then provide file browse item name in  BROWSE FILE give a name for COLLECTION NAME .
 
5. Now just upload a excel file then it will show in Classic Report from apex_collections table.
 
 

BEGIN
   INSERT INTO excle_1

 SELECT C001,
              C002,
              C003   
         FROM apex_collections
        WHERE COLLECTION_NAME ='ATTN_DATA' ;
       
END;
IF APEX_COLLECTION.COLLECTION_EXISTS (p_collection_name => 'ATTN_DATA') THEN

--IF APEX_COLLECTION.COLLECTION_EXISTS (p_collection_name => 'ATTN_DATA') THEN
           --APEX_COLLECTION.DELETE_COLLECTION (p_collection_name => 'ATTN_DATA');
            apex_collection.truncate_collection (p_collection_name=>'ATTN_DATA');

 else null; end if;