Importing a standard Excel XLSX file

Comments

6 comments

  • Avatar
    Michael Becker

    Hi Bill,

    check if that Excel is not saved as a template, that often causes this error.

    0
    Comment actions Permalink
  • Avatar
    Bill Tonissen

    No, not a template as far as I know. (I did not build the file. Aren't those .xlst extensions?) I saved the Excel file in tab-delimited format and added it to the cube successfully using the CSV importer. Don't have the time right now to run it down to a root cause.. maybe later.. 

    0
    Comment actions Permalink
  • Avatar
    Marc Saunders

    I personally would save it as Comma Separated (CSV) as tab can have some unexpected results.

    0
    Comment actions Permalink
  • Avatar
    peter liu

    We've found that files saved in the latest version of Excel appear to cause this issue.  We've had to change our Excel files to CSV format.

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi Peter,

    By latest version you mean?

    0
    Comment actions Permalink
  • Avatar
    Alan Roque

    Hey, 

    That's right, I faced the same issue this afternoon. I had some problems changing to CSV, some data fields were missing after building the elastic cube (null values), so my suggestion is save your time and just save the file as type *.xls  97-2003 it's a workaround that worked for me. 

    0
    Comment actions Permalink

Please sign in to leave a comment.