Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 473 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Load excel using the Data Load option gives an error

Under SQL Workshop, under Utilities, choose Data Workshop.
Select “Load Data” and try to load an XLS file. Getting the following error: "Specified worksheet does not exist in XLSX file."
Am I missing something that needs to be configured?
Best Answer
-
Found the solution...
By opening it in a special repair mode and saving it, I can then open it with Apex.
This is the link that talks about it
Answers
-
The upgrade to a 2007+ file format?
XLS is a different format than XLSX.
They are both different than CSV.
Many times I have seen CSV files with the XLS/XLSX file extension. This is wrong. This is Sooo wrong. Please ensure this is not the case.
I don't use the Data Load Wizard. But I heard that it now supports the XLSX format.
XLS format should no longer be in use. As such, I doubt the Data Load Wizard will ever support XLS format.
Workaround
Save the file as an XLSX file and try again.
MK
-
File is XLSX.
-
Is it really an XLSX file? can you change the extension to ZIP and open it? (this question is a habit of mine. I've seen too many people claim their CSV file is an XLSX file)
Does the XLSX file actually contain the correct worksheet name that the Data Load Service is looking for?
Is it spelled correctly? (don't laugh - I once had someone misspell RAT)
Case matches? (I'm not sure if this is the case. As I've said, I don't use Data Load Service)
Without trailing spaces?
What does the debug log say?
-
File is XLSX sure? You can try again by changing the file extension. or Please re-edit the file and save it in the same format and try to upload and then upload the file. I also had a similar problem once.
-
Found the solution...
By opening it in a special repair mode and saving it, I can then open it with Apex.
This is the link that talks about it