Exporting LabVIEW SignalExpress Data to One Worksheet in Microsoft Excel
Primary Software: LabVIEW Signal Express>>Development System
Primary Software Version: 2.0
Primary Software Fixed Version: N/A
Secondary Software: N/A
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
- Include the Save to ASCII/LVM step
- Under Export file type choose Generic ASCII (.txt).
- 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 click on the white portion of the step (see below), not the blue, to get the Copy Value selection.
or
- Click on 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 samlpes, but for Continuous acquisitions it will only be the most recent samples acquired.
Related Links: NI LabVIEW SignalExpressKnowledgeBase 48FE1884: Importing and Exporting Data in LabVIEW SignalExpress
Attachments:
Report Date: 06/17/2008
Last Updated: 11/13/2008
Document ID: 4MGBOQD4
