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
- Include the Save to ASCII/LVM step.
- Under Export file type choose Generic ASCII (.txt).
- Under Signals choose Add Input to add multiple channels to the file.
- 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.
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.