Is it possible to load a xlsx file with two sheets

Soukaina IDRISSI

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

InoL

And if we suppose that the file is .xlsx, will it be possible ?

Yes, because you can tell which sheet to load. See APEX_DATA_PARSER parameter p_xlsx_sheet_name.

https://docs.oracle.com/en/database/oracle/application-express/19.2/aeapi/PARSE-Function.html

InoL

 one csv file with two sheets

I don't think it is even possible to have a CSV file with two sheets. CSV is just plain text. If you open your 2 sheet file in, for instance, Notepad, how does it look?

Soukaina IDRISSI

Thank you Inol for your reply.

And if we suppose that the file is .xlsx, will it be possible ?

InoL

And if we suppose that the file is .xlsx, will it be possible ?

Yes, because you can tell which sheet to load. See APEX_DATA_PARSER parameter p_xlsx_sheet_name.

https://docs.oracle.com/en/database/oracle/application-express/19.2/aeapi/PARSE-Function.html

Soukaina IDRISSI

Thank you InoL