Exporting LabVIEW SignalExpress Data to One Worksheet in Microsoft Excel

Hardware: PXI/CompactPCI>>Controllers

Problem:
When I use LabVIEW 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?

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

2. Under Export file type choose Generic ASCII (.txt).

3. Under Signals choose Add Input to add multiple channels to the file

4. 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 Excel, opening the .txt file created by LabVIEW SignalExpress

Directly from a 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.

or
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.

Report Date: 06/17/2008
Last Updated: 03/05/2010
Document ID: 4MGBOQD4

Your Feedback!

Poor | Excellent

Yes

Document Quality?

Answered Your Question?

Please Contact NI for all product and support inquiries.