Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is it possible to load a xlsx file with two sheets

Soukaina IDRISSIAug 16 2022 — edited Aug 17 2022

Hi Experts,
Im using APEX21.2, and i want to know if is it possible to load one csv file with two sheets, during a customized loading process.
NB: The data loading must be done in one and only one table, the data display of these two sheets will be on two different steps.

Thank you in advance for help
This post has been answered by InoL on Aug 16 2022
Jump to Answer

Comments

fac586

Install and review the File Upload & Download sample app.

bostonmacosx

Uses the magic of AutoDML......
They use the AUtoDML and target the uploaded file to a particular table.
I just need it to go to the TEMP FILES....

fac586

I have never had any problems using APEX_APPLICATION_TEMP_FILES.
For example this is a process from a multi-stage data loading wizard:

declare

 l_data_file apex_application_temp_files%rowtype;
  
begin

 select
     aatf.*
 into
     l_data_file
 from
     apex_application_temp_files aatf
 where
     aatf.name = :p11_data_file;
    
 apex_collection.update_member(
      p_collection_name => 'ORR_DATA_FILE'
    , p_seq     => '1'
    , p_n001    => l_data_file.id
    , p_blob001 => l_data_file.blob_content
    , p_c001    => l_data_file.name
    , p_c002    => l_data_file.filename
    , p_c003    => l_data_file.mime_type
    , p_c004    => case l_data_file.mime_type
                     when 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' then 'Excel Workbook'
                     when 'text/csv' then 'CSV'
                     else 'Delimited text'
                   end);
   
end;

P11_DATA_FILE is the File Browse item.

1 - 3

Post Details

Added on Aug 16 2022
#apex-discussions
4 comments
133 views