Record data in excel from multiple channel for multiple time

[solehinrobian]

Hi All,

I am trying to import multiple data from multiple source with header to excel file.

when i run the program, it only record the last data send. 

I wonder if there is step that I missed

hopefully your guys can help to advice

thanks in advance

[RTSLVU · Accepted solution]

Try something like this:

You might want to play with the time format as you will see the default does not give you seconds.

[solehinrobian]

Hello,

thanks for your respond.

do you mind to share the file that you make on the picture.

There are few blocks that I am not familiar with

[RTSLVU]

It's actually a code snippet but here you go...

[solehinrobian]

Thank you very much.

unfortunately i cant open the file.

i think it is because you use the latest version of labview compare to what i am use that is 2018 version.

may i know what are these 4 blocks?

 

   

[crossrulz]

---

@solehinrobian wrote:

may i know what are these 4 blocks?

 

   

---

Open/Create/Replace File, Format String, End Of Line Constant, Close File.

You definitely need to read the help for the Format String as it can do a lot when it comes to the format string.

[crossrulz · Accepted solution]

I decided to do some edits myself.  Here is more of what I would do.  I would have the data in an array and then use Array To Spreadsheet String to build up most of the line of data.  If time is really required, then I would do that with the Format String.  The Array To Spreadsheet String ends with the end of line, so we don't have to worry about adding that anywhere.

As an additional comment, I have found myself not using a CSV format because some places use the comma instead of a decimal point.  So I use tab delimited text files, which Excel can still read with no issues.

[solehinrobian]

It works now.

 thank you guys for your helps!

[RTSLVU]

---

@crossrulz wrote:

As an additional comment, I have found myself not using a CSV format because some places use the comma instead of a decimal point.  So I use tab delimited text files, which Excel can still read with no issues.

---

I tend to agree with this but the OP was making a CSV so I just stuck with it.

[crossrulz]

---

@RTSLVU wrote:

---

@crossrulz wrote:

As an additional comment, I have found myself not using a CSV format because some places use the comma instead of a decimal point.  So I use tab delimited text files, which Excel can still read with no issues.

---

I tend to agree with this but the OP was making a CSV so I just stuck with it.

---

Stick to the actual requirement.  If the only actual requirement is "a file that can be read in Excel", then I will push for a tab delimited text file.  If the requirement is a CSV, then stick with what we did.  I just made this comment to give people something to consider before going too far down the line.