07-04-2011 07:37 AM
hi
Any suggestions?(see the picture). i need to write this value in Excel, but seems to be incompatible formats.
using Labview 2010.
thanks
07-04-2011 09:01 AM - edited 07-04-2011 09:05 AM
First, you need to transform the timestamps to strings. There's several ways to do that, have a look at "Format Date/Time String" for instance.
Then you need to insert a "Build Array" to add a dimension to the 1D array. This will result in a 2D array, which you might have to transpose before writing to Excel.
07-04-2011 02:06 PM
Are you trying to write out a single "row" (or column) in Excel? As I recall, the LabVIEW Excel reports like to write out "areas", i.e. a 2-D structure. To write a single row, simply push the 1-D array through "Build Array" (with only the single input) and it creates a suitable 2-D array. Note to write a single cell, you'd push it through two such Build Array components (once to build a 1-D row, next to build a 2-D "area").
07-05-2011 01:43 AM
I am trying to get these values in Rows. i will try your suggestion
thanks