nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

60872_en-US

liliconcom

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 )
   )
);