IBM Support

PI77963: EXCEL XLSX IMPORT FAILS IN 24 FP1 WITH ERROR (2063) WHEN SOME COLUMNS HAVE FORMULAS IN THE EXCEL FILE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • You work with IBM SPSS statistics 24 fixpack1 installed and
    would like to import a MS Excel *.xlsx file. Your Excel file has
    about 217 data rows. However, in row 218 and 219 of this file
    you see some sums or other values that are created with some
    column formulas in the Excel file; with columns where you divide
    a column of numbers by a constant number as signified by the $
    (dollar sign).
    
    You try to import the complete excel file in SPSS 24 with a
    syntax like the below example:
    
    
    GET DATA
      /TYPE=XLSX
      /FILE='C:\Users\test\test.xlsx'
      /SHEET=name 'Sheet1'
      /CELLRANGE=FULL
      /READNAMES=ON
      /LEADINGSPACES IGNORE=YES
      /TRAILINGSPACES IGNORE=YES
      /DATATYPEMIN PERCENTAGE=95.0
      /HIDDEN IGNORE=YES.
    EXECUTE.
    
    If you run the syntax you see the file is not imported at all.
    You get below error on output Viewer:
    
    Error.  Command name: GET DATA
    (2063) Error reading information for sheet.
    * Sheet Name: "Sheet1"
    Execution of this command stops.
    EXECUTE.
    

Local fix

  • Normally it is not supported to import excel files with such
    formulas in the Columns. As a workaround remove either the
    formulas or remove the last two rows in the Excel file with the
    sums of these columns. Save the file with a new name and import
    the altered Excel file.
    This will work without any error.
    This issue is expected to be addressed in a future release.
    Please use the workaround described above.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * This affects all users of SPSS Statistics.                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * EXCEL XLSX IMPORT FAILS IN 24 FP1 WITH ERROR (2063) WHEN     *
    * SOME COLUMNS HAVE FORMULAS IN THE EXCEL FILE                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please upgrade to IBM SPSS Statistics 25.0 to resolve this   *
    * issue.                                                       *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI77963

  • Reported component name

    SPSS STATISTICS

  • Reported component ID

    5725A54ST

  • Reported release

    O00

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-03-10

  • Closed date

    2017-08-09

  • Last modified date

    2017-08-09

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

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

Fix information

Applicable component levels

  • 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:
09 August 2017