LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

how to save values and information in a spreadsheet?

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

0 Kudos
Message 1 of 15
(3,554 Views)

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.

0 Kudos
Message 2 of 15
(3,548 Views)

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

0 Kudos
Message 3 of 15
(3,534 Views)

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.

0 Kudos
Message 4 of 15
(3,519 Views)

Yes, I saw that haha 😛

Well I take a look at some examples... but nothing really close with that =/

 

I'm trying here haha

0 Kudos
Message 5 of 15
(3,512 Views)

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.

 

========================
=== Engineer Ambiguously ===
========================
0 Kudos
Message 6 of 15
(3,495 Views)

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.

 

 

Message Edited by EduU on 05-21-2010 07:30 AM
0 Kudos
Message 7 of 15
(3,473 Views)
A carriage return.
0 Kudos
Message 8 of 15
(3,460 Views)

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?

0 Kudos
Message 9 of 15
(3,453 Views)

\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.

0 Kudos
Message 10 of 15
(3,446 Views)