05-20-2010 09:59 AM
Well guys I want to create a spreadsheet.xms and save some values in this spreadsheet.
My problem is, when I'm creating the spreadsheet I don't know how can I put where I will save the values.
Because I need each one in a specific row and collum.
Like I need the value 0,33 goes to row 3 collum B
value 0,45 goes to row4 collum B
something like that, also I need in collum A some text files. Like information
in row 3 collum A example: "value from test 1" so in collum B the value "0,33"
Anyone can help me make that?
Thanks
05-20-2010 10:11 AM
What is an ".xms" file?
If you were doing this in Excel, then search the forums for Excel and read the Excel thread for links to threads that give good examples for working with Excel.
05-20-2010 10:30 AM
Well Ravens, I did a post there... with the link from this post
So I will wait for answers, thanks =D
and sorry, I want to say "XLS" instead of "XMS" sorry for that! =x
05-20-2010 10:55 AM
No. Don't post a message there.
Just go through that thread, read the messages, and click on the links to find some more detailed threads about how to work with .xls files in LabVIEW.
05-20-2010 11:10 AM
Yes, I saw that haha 😛
Well I take a look at some examples... but nothing really close with that =/
I'm trying here haha
05-20-2010 01:16 PM
Don't think "Excel" think "Array"
Put all your data and any headers in an array then use the "array to spreadsheet" VI and dump it to a file after that.
05-21-2010 07:28 AM - edited 05-21-2010 07:30 AM
Hey RTSLVU, Thanks for the help
I was looking here.. I only find "array to spreadsheet string" well I think it works anyway.
As you are saying, I will put the data in array and the string in this VI, so I will get a spreadsheet string...
how can I save it as a file, after that?
another thing, how is the command to go to next line in excel?
tab goes to another collum, I need to know which command I put to go to next row.
05-21-2010 08:58 AM
05-21-2010 09:19 AM
Yes I know is a return... but what is the code for it?
like, tab is \t
return is ??
I already tryed a lot of letters here and don't work x(
or have another way to make it?
05-21-2010 09:33 AM
\r is a carriage return (decimal 13, hex 0D)
\n is a line feed (decimal 10, hex 0A)
Of course \r and \n is what you would see if you have the string constant or control set to display \codes.