Skip to Main Content
  • Questions

  • Upload XLSX file to table in oracle apex

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, PurushothamReddy.

Asked: May 09, 2025 - 10:26 am UTC

Last updated: May 12, 2025 - 3:16 am UTC

Version: APEX 24.2

Viewed 1000+ times

You Asked

I want to upload multiple XLSX files, each containing multiple sheets. The data from each sheet should be inserted into a table with the same name as the sheet (the tables already exist) using Oracle APEX. Is this possible?

and Connor said...

Check out APEX_DATA_LOADING

https://docs.oracle.com/en/database/oracle/apex/23.1/aeapi/APEX_DATA_LOADING.html#GUID-D45764A0-5A56-422C-9D51-FC1FE26E52A7

It lets you nominate which sheet to be loaded


more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.