11-19-2015 09:00 AM
I created a VI which takes in data from a scale and outputs time and mass to an excel template using the Report Generation Toolkit for Microsoft Office. Right now I have a 1D array of time and a 1D array of mass wired to the report generation block. Even though they are each 1D arrays, they both export as 2D arrays where the first column is data point numbers (1,2,3...etc.) and the second column is the actual data. My question is how do I remove the data point label columns so that in my report I only have the time and mass columns.
Thanks,
Cpraz
11-19-2015 09:42 AM
This will paste only the second column into Excel (as a column).
11-19-2015 10:24 AM
So that was my mistake. The data is exporting as a 1D array, so this method doesn't work. The 1D array connects to the MS Office Report but in the report, the data comes in two columns (one of sequential data labels, and one of the actual data).
11-19-2015 10:28 AM
A 1D array is even easier:
11-19-2015 10:30 AM
If you want the arrays right next to each other, you can build them both into the "build array" function so you only write to the Excel sheet once.