Load excel using the Data Load option gives an error

Tomek

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?

Tomek

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

Mike Kutz

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

Tomek

File is XLSX.

Mike Kutz

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?

Sanjay Sikder

@Tomek,

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.

Tomek

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