Company Events Academic Community Support Solutions Products & Services Contact NI MyNI

Configure Advanced Excel Options Dialog Box

LabVIEW 2013 Help

Edition Date: June 2013

Part Number: 371361K-01

»View Product Info

Requires: Base Development System

In the configuration dialog box of the Write To Measurement File Express VI, select the Microsoft Excel (.xlsx) option from the File Format section and click the Advanced button to display this dialog box.

Use this dialog box to specify the time format for the data you want to write to a Microsoft Excel file.

Note  LabVIEW ignores all options in this dialog box if you select the Empty time column option in the configuration dialog box of the Write To Measurement File Express VI.

This dialog box includes the following components:

  • Absolute—Specifies whether you want to use relative time or absolute time for the data. If you place a checkmark in this checkbox, this Express VI writes the timestamp by using the time when you acquired the data. If you remove the checkmark from this checkbox, this Express VI writes the timestamp in terms of the time elapsed since 12:00 a.m., January 1, 1904, Universal Time [01-01-1904 00:00:00]. This checkbox contains a checkmark by default.
  • Format—Specifies the format of the timestamp you want to use in the Excel file. The following table lists commonly used timestamp formats:

    Date Format Time Format
    yyyy/mm/dd hh:mm
    yyyy-mm-dd hh:mm:ss
    yyyy.mm.dd hh:mm:ss.000
    mm/dd/yyyy
    dd/mm/yyyy

 

Your Feedback! poor Poor  |  Excellent excellent   Yes No
 Document Quality? 
 Answered Your Question? 
Add Comments 1 2 3 4 5 submit