Loading Excel File

sekrausesekrause MemberPosts:2Contributor I
edited December 2018 inHelp

When trying to load an excel file , I'm getting the following error

"Error loading sheet content. Reason: The selected XLSX file seems to be malformed as it is missing a required file entry: 'xl//xl/worksheets/sheet1.xml'

I converted the data to csv and it loaded, but am wondering what the reason behind this error is and more importantly what I can do to prevent it.

Thanks

Tagged:

Answers

  • Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:1,761Unicorn

    There appears to be a problem with the XLSX file, does it contain any special macros or addins? Was it created with Excel or exported from some other 3rd party software?

  • sekrausesekrause MemberPosts:2Contributor I
    Thanks for getting back so soon.

    I exported it from SAS Base
  • Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:1,761Unicorn

    这可能是problem. Normally we read XLSX in just fine but sometimes 3rd party exporters do something wonky. I would suggest exporting it as a CSV from SAS software.

Sign InorRegisterto comment.