Forum Stats

  • 3,855,345 Users
  • 2,264,499 Discussions
  • 7,905,975 Comments

Discussions

Categories

Load excel using the Data Load option gives an error

Tomek
Tomek Member Posts: 234 Bronze Badge
edited Apr 8, 2020 11:48AM in APEX Discussions

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."

pastedImage_0.png

Am I missing something that needs to be configured?

Tagged:
Sanjay Sikder
· Share on TwitterShare on Facebook

Best Answer

Answers

  • Mike Kutz
    Mike Kutz Member Posts: 6,200 Silver Crown
    edited Apr 1, 2020 3:03PM

    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

    Sanjay Sikder
    · Share on TwitterShare on Facebook
  • Tomek
    Tomek Member Posts: 234 Bronze Badge
    edited Apr 1, 2020 4:28PM

    File is XLSX.

    · Share on TwitterShare on Facebook
  • Mike Kutz
    Mike Kutz Member Posts: 6,200 Silver Crown
    edited Apr 1, 2020 5:12PM

    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?

    · Share on TwitterShare on Facebook
  • Sanjay Sikder
    Sanjay Sikder Member Posts: 14 Red Ribbon
    edited Apr 2, 2020 4:37PM

    @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.

    · Share on TwitterShare on Facebook
  • Tomek
    Tomek Member Posts: 234 Bronze Badge
    edited Apr 8, 2020 11:47AM Answer ✓

    Found the solution...

    By opening it in a special repair mode and saving it, I can then open it with Apex.

    pastedImage_1.png

    This is the link that talks about it

    · Share on TwitterShare on Facebook