National Instruments BridgeVIEW 用户手册

Appendix A

HMI Function Reference

© National Instruments Corporation

A-29

Historical Trends to Spreadsheet File

This VI stores the data from a set of historical trends into a spreadsheet file format. The 
columns created are date, time, tag1data, tag2data, and so on. A header is created labelling 
the date, time, and tag names. The default delimiter is the tab character; sending a different 
value via the format info input (such as a comma) will change the character used to separate 
columns.

You can also override the default date and time format by wiring a different value to the date 
& time format input. To customize the file dialog behavior (if the file path input is an empty 
path or Not A Path), use the file info input.

file info describes information to customize the file prompt and creation 
behavior.

prompt is the messages that appears below the list of files and 
directories in the file dialog box.

function function is the operation to perform.

default name is the initial file name that appears in the selection 
box of the File dialog box.

pattern is the match pattern specification used to display only 
certain types of files or directories.

format info Contains spreadsheet formatting information

delimeter (tab) is the separator to be used inteh spreadsheet 
format. The default is a tab.

date header is the cloumn header for the date information.

time header is the column header fr the timestamp information.

date & time format is a cluster that contains settings used to format the 
date and time in the spreadsheet string. 

date format (System default) determines the format for the date.