CODEWITHSUNDEEP
exceloracle-databaseoracle-apex
Bumi
Bumi

Reputation: 11

How To Load Data From Excel To Oracle Database Using Apex

I have an excel file, and there is a merge cell on the title column name, how can I load that data into my oracle database using APEX without editing my excel file.

Thank you

Upvotes: 0

Views: 596

Answers (1)

Littlefoot
Littlefoot

Reputation: 143083

If you used the Wizard and chose "Data Loading" page type, then it contains

  • first row has column names (Yes / No)

option. So, if it is the first row and it has merged cells, then answer "Yes" and you'll skip that row. Otherwise, I'm not sure that you can do that without editing the input (Excel) file.

Upvotes: 2

Related Questions