write to spreadsheet Help

[JayP]

Hello, I am trying to use write to spreadsheet file.vi to store my energy measurement data to an excel file. When I open the file after it saves data it comes out in a row instead in a column which will make my life much easier. I also tried to put shift register on this for loop it will save the data in the file for all the measurements instead of reseting to only new data, but it gives me errors about connecting two different data types. Any help will be greatly appreciated.

[Giedrius.S]

What if you would transpose?

[JayP]

Never looked at that!!!!!!Transpose takes care of the column problem. Thanks a lot Giedrius.S!!! Any ideas about the shift registers probelm???

[RavensFan · Accepted solution]

I don't see any shift registers in your program, so I don't know about that problem.

But perhaps you want to wire a True to the Append Data? input so it doesn't overwrite old data?

[JayP]

As you can probably tell I am new to labview.I have taken basic courses though and that is why I always think of shift registers when trying to do something like this. I will wire a true to the append Data and see if that eliminates the need of the shift registers. Greatly appreciate your help!!!

[JayP]

I wired a true to the Append Data and that eliminates the need of shift registers I was thinking about. Thanks again.