332858_en-US

liliconcom

Millisecond import with Excel Wizard

Hello,

I have the problem that I want to import time stamps in the format "dd.mm.yyyy hh: mm: ss.sss" with the Excel Wizard. Unfortunately, the decimal places of the seconds are lost. With the use of the JMP Excel add-in it works perfectly. But not with the wizard.

Does anyone have any idea how to get the 3 decimal places of the time stamp when importing?

 

Thanks for your help in advance

Markus

Data tableRe: Millisekunden Import mit Excel WizardIs the issue that the 3rd decimal value is missing, or that the format specification is only displaying 2 decimal points?Re: Millisecond import with Excel Wizard

The information is missing

Re: Millisekunden Import mit Excel WizardCan 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 columnRe: Millisecond import with Excel Wizard

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( "-" )
 )
)

Re: Millisekunden Import mit Excel Wizard

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