SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 

 View Only

  • 1.  spss v29 not reading openpyxl file

    Posted 28 days ago

    I'm getting the error message '(2003) All sheets in Excel file appear to be empty' when attempting to open an openpyxl file that isn't empty?  



    ------------------------------
    Art Jack
    ------------------------------


  • 2.  RE: spss v29 not reading openpyxl file

    Posted 21 days ago

    Hi @Art Jack,

    I'm not familiar with using openpyxl within an IBM SPSS Statistics program block, or just in concert with IBM SPSS Statistics. IBM SPSS Statistics is capable of reading and writing Excel workbook files natively.  Is there something about your implementation that is not allowing you to use spss.Submit() and the associated GET DATA and SAVE TRANSLATE SPSS Statistics command syntax?



    ------------------------------
    David Dwyer
    Global Solution Consultant
    IBM
    ------------------------------

    Original Message


  • 3.  RE: spss v29 not reading openpyxl file

    Posted 20 days ago
    Hi David, the file I'm trying to read in was saved through python's excel library.  The extension for the file is .xlsx.  If I open it and save it without doing anything it will read it in.

    Sent from my iPhone



    Original Message


Related Content