600819_en-US

liliconcom

problem importing date from excel

Morning,

 

I have this excel file with 2 date columns.

 

when I import directly into Jmp, the preview gives this:

when I import, I have this:

if I go through a script like this:

Names Default To Here( 1 );
 dt1 = Open(
   "/E:/Pb date.xlsx",
   Worksheets( "Feuil1" ),
   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 ),
    Replicated Spanned Headers( 0 ),
    Suppress Hidden Rows( 1 ),
    Suppress Hidden Columns( 1 ),
    Suppress Empty Columns( 1 ),
    Treat as Hierarchy( 0 ),
    Multiple Series Stack( 0 ),
    Import Cell Colors( 0 ),
    Limit Column Detect( 0 ),
    Column Separator String( "-" )
   )
  );


Column( dt1, "Date de fab 2022" ) << data type( Numeric ) << Modeling Type( Ordinal ) << Format( "d/m/y", "-1", "NO", "" );
Column( dt1, "Date de fab" ) << data type( Numeric ) << Modeling Type( Ordinal ) << Format( "d/m/y", "-1", "NO", "" );

I get this:

I tried by changing the formats in the script. I did not succeed in importing the second column date in numerical format, continue.

 

I don't understand.

 

if anyone has the solution....

 

Cordially.

Data Table