![background image](http://html1.mh-extra.com/html/national-instruments/bridgeview/bridgeview_user-manual_3445534349.webp)
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.