IBM Support

PI61788: UNABLE TO IMPORT AN XLSX FILE INTO STATISTICS 24 (AND 23 FP3), GET ERROR 2063 - ERROR READING INFORMATION FOR SHEET

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • You work with IBM SPSS Statistics 24 or 23 FixPack 3 release.
    You have an Excel file where a numeric variable with decimal
    values is formatted as type 'General' in Excel with left aligned
    cells.
    You can import this Excel *.xlsx file without any problem into
    IBM SPSS Statistics 23 FP2.
    However, in release 24 for example you click on 'File - Import
    Data - Excel' dialog and select your XLSX file.
    You see on Read Excel Data dialog there is no preview of the
    data displayed.
    When you click OK on the dialog the file is not imported.
    Instead you see an error like the below on output viewer:
    
    Error.  Command name: GET DATA
    (2063) Error reading information for sheet.
    * Sheet Name: "<your sheet name>"
    Execution of this command stops.
    EXECUTE.
    
    Error # 105.  Command name: EXECUTE
    This command is not valid before a working file has been
    defined.
    Execution of this command stops.
    
    This was reported to IBM SPSS Development. As a workaround open
    your file in Excel and format the entire column as NUMBER with 2
    decimal digits and save the xlsx file. Import this file instead
    to SPSS and it will work fine. The issue also only happens when
    you use a non-English regional setting on Control Panel -
    Regional settings.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * see APAR text                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * This issue has been addressed in IBM SPSS Statistics 24      *
    * FixPack 2.                                                   *
    * Please download from http://www.ibm.com/support/fixcentral   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * This issue has been addressed in IBM SPSS Statistics 24      *
    * FixPack 2.                                                   *
    * Please download from http://www.ibm.com/support/fixcentral   *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI61788

  • Reported component name

    SPSS STATISTICS

  • Reported component ID

    5725A54ST

  • Reported release

    O00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-05-03

  • Closed date

    2017-05-10

  • Last modified date

    2017-05-10

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    SPSS STATISTICS

  • Fixed component ID

    5725A54ST

Applicable component levels

  • RO00 PSN

       UP

  • RO00 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCQ88K","label":"Statistics Desktop"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"O00","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
10 May 2017