Write NI SignalExpress Data to a Single Worksheet in Excel

Updated May 1, 2018

Reported In

Software

  • SignalExpress

Other

  • Microsoft Excel

Issue Details

  • When I use SignalExpress to export multiple channels by right-clicking a task and choosing Export to Microsoft Excel, I get a separate worksheet for each channel. How do I get the data to export to one worksheet?
  • How do I write all channels in SignalExpress to a single Excel worksheet?

Solution

There are two methods to export data to Microsoft Excel so that multiple channels get placed in one worksheet: 

Using a file created by SignalExpress

  1. Include the Save to ASCII/LVM step. 
  1. Under Export file type choose Generic ASCII (.txt)
  1. Under Signals choose Add Input to add multiple channels to the file.
 
  1. After running the project, open the .txt file in Excel by either:
    • Right-clicking the file and selecting Open With and choosing Microsoft Office Excel from the list, or
    • From a blank worksheet inside Microsoft Excel, opening the .txt file created by SignalExpress.
 

Directly from a SignalExpress step

There's two ways to do it from the SignalExpress step:
  •  Right-click the step with multiple channels and choose Copy Value, then paste it into Excel. Be sure to click the white portion of the step (see below), not the blue, to get the Copy Value selection.
    • Note: For SignalExpress 2015, right-click the step's input and select Export To > Clipboard (Text).
 
  • Click the task within the step and, while holding down the mouse button, drag the selection into an open Excel workbook
    • Note: This method only saves the number of samples specified in the Samples to Read field within the DAQmx Acquire task. For Finite (N Samples) acquisitions this will include all samples, but for Continuous acquisitions it will only be the most recent samples acquired.

Additional Information

If you are using Signal Express LE, you are able to log data to a single Excel file; whereas, in Signal Express Full, you are able to log to multiple Excel files. Consult our comparison guide for other differences between the two versions of Signal Express.

The amount of data that you are able to write in a single worksheet is limited by the number of rows of data that can be saved in Excel

WAS THIS ARTICLE HELPFUL?

Not Helpful