LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Report Generation Toolkit 1D Array Data Labels

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

0 Kudos
Message 1 of 5
(3,595 Views)

This will paste only the second column into Excel (as a column).

 

strip first column.png

0 Kudos
Message 2 of 5
(3,585 Views)

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

0 Kudos
Message 3 of 5
(3,564 Views)
0 Kudos
Message 4 of 5
(3,558 Views)

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.

0 Kudos
Message 5 of 5
(3,553 Views)