Alarm & Event Query To Spreadsheet File VI doesn't work correctly (DSC 7.1)

[AndrewWilliams]

I am using the Alarm & Event Query To Spreadsheet File VI to write
alarms/events to an Excel spreadsheet. However there are two things it
does wrong:

1. Global variables in the header are not correctly inserted. I am
using the header "{creationDate}{delimiter}{creationTime}" but none of
the variables are translated to their actual values. The same header
in Write Traces To Spreadsheet VI works correctly, so I assume it is
only the Alarm & Event Query To Spreadsheet File VI that isn't
working.

2. My display format is set to display the date of the alarms but it
never appears. Set time/ACK time, etc all appear, just not the date.

Can anyone explain what might be wrong?

[JD Robertson]

Hello,

In answer to your questions:

1) The documentation for the Alarm & Event Query To Spreadsheet File
VI is incorrect. The header and footer fields do not support global
variables. The header and footer text will be copied to the output
file “as is”. If you would like to add the date and time to your
output, you can use the LabVIEW Get Date/Time String primitive to
construct the appropriate header.

2) I’m not completely sure that I understand what you are expecting
here. Can you provide an example of what you are seeing, and what you
expect the correct behavior to be?

J.D. Robertson
Software Engineer
National Instruments