0

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

Improve this question
2
  • APEX 18 and earlier do not include support for Excel files, you'll need to use a 3rd-party library. I list a number of options here: jeffkemponoracle.com/2018/11/load-spreadsheet-data-into-apex. APEX 19.1 current Statement of Direction, as well as the early adopter release, indicates they will include API support for reading XLSX files. Commented Feb 11, 2019 at 8:16
  • Thank you so much, Commented Feb 27, 2019 at 8:06

1 Answer 1

Reset to default
2

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

The APEX Data Loader only supports CSV files (at this time).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.