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

Millisekunden Import mit Excel Wizard

markus

Hallo,

Ich habe das Problem, dass ich mit dem Excel Wizard Zeitstempel im Format "dd.mm.yyyy hh:mm:ss.sss" importieren möchte. Leider gehen dabei die Nachkommastellen der Sekunden verloren. Mit der Benutzung des JMP Excel-Add-ins funktioniert es einwandfrei. Mit dem Wizard jedoch nicht.

Hat jemand eine Idee, wie man beim Import die 3 Nachkommastellen des Zeitstempels erhalten kann?

Danke für eure Hilfe im Voraus

Markus

Accepted answers

txnelson

It is time to turn this over to JMP Support.
support@jmp.com

All comments

txnelson

Is the issue that the 3rd decimal value is missing, or that the format specification is only displaying 2 decimal points?

markus

The information is missing

txnelson

Can you share the Open() function the Excel Wizard produced to input the file. It may shed some light on how it is handling the input. You may just have to change the format being used to read the date/time column

markus

Do you want to see this:

Open(
	"D:\Excel\20190301052441_FU1523.xlsx",
	Worksheets( "XXX" ),
	Use for all sheets( 1 ),
	Concatenate Worksheets( 0 ),
	Create Concatenation Column( 1 ),
	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( "-" )
	)
)

txnelson

When you open your Excel file, use the Excel Wizard, and go to the column in question, and right click on the header and select the format you want to use for the column, making sure you specify 3 decimal places

You will then get a modified input JSL which should fix you issue

Open(
	"C:\Users\Jim\Documents\Discussion Group\time.xlsx",
	Worksheets( "time" ),
	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 Numeric Format(
			Index( 0 ),
			Column Name( DateTime ),
			Format( "m/d/y h:m:s", 27, 3 )
		)
	)
)