user specified formatted Excel File

[P.Rayne]

Hello all,
this forum has been extremely helpful to me earlier...i'm hoping for
the same this time around.

here is my query:

I need to write information to an Excel file in a formatted fashion,
as usual i'm using open book, open sheet, set value with range... i
would like to format the data that i read from the PLC in to the EXCEL
file in a specified manner is there a way to do this...
date on the first row,
columns seperated by colons ":" and then column names and the
respective data below them...

thanks,
cheers,
-U

[BJD1613]

Try using the format into string function in the string subpalette. This will allow you to enter all of your inputs and build a string to write to file. You can use string constant to create the ":" and you can use a variety of tabs, end of lines, etc. to build the string the way you want. If you have LV 7 you can use the Build Text express vi. This will allow you to format easier with a nice property page. The drawback with using the build text is a limit of 8 inputs. The format into string will allow more than 8. Hope this helps.