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?

[jdr_ni]

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