Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted

Import (open) data from excel: data columns empty

Has anyone run into the case where you import data and one or more columns show no data in JMP? I'd appreciate any insights.

 

I've been using this script (with identifying features removed of course):

Open(
    "C:\My documents\excelly.xlsx",
    Worksheets( "DATASTUFF" ),
    Use for all sheets( 1 ),
    Concatenate Worksheets( 0 ),
    Create Concatenation Column( 0 ),
    Worksheet Settings(
        1,
        Has Column Headers( 1 ),
        Number of Rows in Headers( 1 ),
        Headers Start on Row( 1 ),
        Data Starts on Row( 2 ),
        Data Starts on Column( 1 ),
        Data Ends on Row( 0 ),
        Data Ends on Column( 0 ),
        Replicated Spanned Rows( 1 ),
        Suppress Hidden Rows( 1 ),
        Suppress Hidden Columns( 1 ),
        Suppress Empty Columns( 1 ),
        Treat as Hierarchy( 0 )
    )
);

1 REPLY 1
txnelson
Super User

Re: Import (open) data from excel: data columns empty

can you attach the spreadsheet?

Jim
Article Labels

    There are no labels assigned to this post.