probleme import date excel

Françoise

bonjour,

 

je n'arrive pas à avoir le bon format dans JMP (d/m/y) comme dans excel et après plusieurs essais, j'ai toujours dans JMP: m/d/y.

 

merci pour votre aide

 

cordialement

essai date.xlsx

hcarr01

Maybe you can use the following script : 

Names default to here(1);
clear log();
clear symbols();
clear globals();

path = use your correct path... 

// Importer un fichier Excel : essai date.xlsx
// → Data Table( "Feuil1" )
Open(
	path,
	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( 4 ),
		Headers Start on Row( 1 ),
		Data Starts on Row( 5 ),
		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( 0 ),
		Treat as Hierarchy( 0 ),
		Multiple Series Stack( 0 ),
		Import Cell Colors( 0 ),
		Limit Column Detect( 0 ),
		Column Separator String( "-" ),
		Column Numeric Format(
			Index( 0 ),
			Column Name( "Datectrl + ;"n ),
			Datatype( "Character" )
		),
		Column Numeric Format( Index( 7 ), Format( "Best", 9 ) ),
		Column Numeric Format(
			Index( 11 ),
			Format( "Best", Use thousands separator( 1 ), 9 )
		),
		Column Numeric Format(
			Index( 12 ),
			Format( "Best", Use thousands separator( 1 ), 9 )
		),
		Column Numeric Format( Index( 13 ), Datatype( "Character" ) ),
		Column Numeric Format( Index( 14 ), Format( "d/m/y", 10 ) ),
		Column Numeric Format( Index( 15 ), Datatype( "Character" ) )
	)
);


// Modifier les informations de colonne : Datectrl + ;
Data Table( "Feuil1" ):"Datectrl + ;"n <<
Set Data Type(
	Numeric,
	Format( "Format Pattern", "<DD>/<MM>/<YYYY>", 10 ),
	Input Format( "Format Pattern", "<DD>/<MM>/<YYYY>" )
) << Set Modeling Type( "Continuous" ) << Set Field Width( 12 );