Loading Excel File

sekrausesekrause Member Posts: 2 Contributor I
edited December 2018 in Help

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

Answers

  • Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,761 Unicorn

    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 Member Posts: 2 Contributor I
    Thanks for getting back so soon.

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

    That might be the 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 In or Register to comment.