labview to excel

[CrisSTine01]

Hello,t I want an automatic generation of an excel file every time I run my program to record a digital values , what I want is  to impose to the function writing in a measurment file the text of the column headers, here is what I get for now.

thank you in advance 🙂

[GerdW]

Hi ramlus,

two solutions:

1. Don't use the expressVI and use WriteToSpreadsheetFile. Use two calls to write the header and the data…

2. When using DDT you can set a name for each signal. This name/label will be used in the Write-ExpressVI…

[CrisSTine01]

Hi, thank you for your answer 🙂

please do you have any examples  to follow, i prefer the second sollution 🙂

[GerdW]

Hi Ramlus,

read the LabVIEW help…

[CrisSTine01]

I try it for one signal and it works shoud I repeat it for every signal ?? could I put all the signals on one DDT ?? 

[GerdW]

Hi Ramlus,

yes.

And yes…

[CrisSTine01]

thank you, but how to define a name for each signal on the same DDT ??? 

[GerdW]

Hi ramlus,

you didn't asked for "How?", only "Can I?"… 😄

Basic LabVIEW knowledge, taught in free online courses and example VIs:

- When you want to repeat a task you should use a loop.

- You can "bundle" DDT signals using the JoinSignal ExpressVI…

[CrisSTine01]

lol ok ,  in fact i'm just asking how to put a name for each signal in the same DDT. because the signal index entry and the name exists for only one signal 😕 

[GerdW · Accepted solution]

Hi Ramlus,

wire the index and name for each signal in your DDT wire - a loop with an autoindexing name array would fit here nicely…

You should know how many signals there are in your DDT as you created that on your own!