1-D Array logging as a column

[asas]

Is there any possible way to log a 1-D array being acquired as a column in a spreadsheet, rather than one long row.

[Dennis_Knutson]

What are you using to create the file? Are you using Write to Spreadsheet File and creating a text file or are you writing straight to Excel with ActiveX? If you're using ActiveX, what VI are you using for that?

[Zvezdana S.]

Hi,
If you are using Write to Spreadsheet File VI, you can use "transpose?" input to write your 1D array as a column or as a row.

If you use ActiveX to send this array to a spreadsheet, you can transpose the array by using Transpose 2D Array function. You will first need to build your 1D array into 2D with the Build Array function. Look at the block diagram of Write to Spreadsheet VI to see how these 2 functions are used.

Zvezdana S.
National Instruments

[asas]

Dennis, I'm using the Write to Spreadsheet File and I saw someone say in a post here that you can't make it into a column for a 1-D array? Thanks

[Dennis_Knutson]

You can make it into a column. Just select transpose.