🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

"Excel Import Problems [SOLVED]"

User: "jeff"
New Altair Community Member
Updated by Jocelyn
Hi - just installed RM 5.3.7.  When importing Excel files the data previews are all wrong.  The first column of data is repeated across all columns.  I have tried this on several computers with 5.3.7 installed and they all have the same problem.  Any thoughts?

Find more posts tagged with

Sort by:
1 - 4 of 41
    User: "Marco_Boeck"
    New Altair Community Member
    Hi,

    just done a quick test, neither .xls nor .xlsx files show the described behavior for me. Can you upload a minimal example file to reproduce the problem?

    Regards,
    Marco
    User: "jeff"
    New Altair Community Member
    OP
    Hi,

    Thanks for the response.  Sorry it has taken awhile for me to get back to you - traveling.
    The data is the Fisher Iris data.  I have litterally tried this on 6+ different computers and the results are the same.  
    Steps 1, 2, and 3 of the Excel import all look fine.  When I get to step 4, the data from column 1 is repeated in all columns.  That makes choosing the column to be "Label" a little more challenging.  Of course I know that Column E contains the label and has the proper name (Species); however, the data in Column E of the preview shows the column A data (as does Columns B,C,D and E).

    I should say that setting Col E as type Label does work.  That is, the data actually imports correctly even though the display of what is in the columns is incorrect.  It is off putting however.

    The Excel file and a screen capture of step 4 of the import can be seen here:
    https://drive.google.com/folderview?id=0B9Pf2efM6_LkNWNhSXlfWnBOeWM&usp=sharing

    Thanks for any advice/help.
    Best
    JR
    User: "jeff"
    New Altair Community Member
    OP
    Instead of importing an Excel Sheet I saved the sheet as a CSV and imported that.  Step 4 of the CSV import exhibited the same exact behavior as the Excel Sheet import.  That is, in step 4 of the import the Col A data is "previewed" across all columns.  The column Name values are correct and the suggested data types are correct but the preview data is not reflective of the actual column data except for Col A.
    User: "Marco_Boeck"
    New Altair Community Member
    Hi,

    thank you for the detailed report and test data  :)
    We have verified and fixed the bug in the latest development version.

    Regards,
    Marco