Write to spreedsheet file from DAQ

[antoniosaninge]

Hi!

I'm making a program to acquire data from a DAQ, I made a programm and get the information whit a Write LabVIEW measurement file but it's impossible to change the header, for that reason, now I'm trying to make it whit a write to spreedsheet file.vi to introduce it the label which I want, but I dont know why my program doesn't generate a file from write top spreedshet.

[GerdW]

Hi Antonio,

I dont know why my program doesn't generate a file from write top spreedshet.

I guess it could generate a file…

WriteToSpreadsheetFile has a lot more inputs than just to 1D array you wired to it. Did you read the LabVIEW help for this function?

Do you mind to wire all needed inputs of this function?

Why do you convert the DDT wire to a 1D array when you measure 3 channels with 8k samples each?

[antoniosaninge]

Hi GerdW thanks for your response,

I want to create a text file with a header one chanel under that header, a new header and 2channel and a final header and 3channel.

I read labview help, but it doesn't solve my problem and I dont know how can I do that

[antoniosaninge]

I got a file with data from DAQ but this block only has the option tu use a header that you cannot change.

My doubt is if there is any possibility to change header text to put the text I need because I will use the text file with another software which need an specific text to run

Regards

[Minions · Accepted solution]

What about doing this after the file with the wrong header is created?

Or using whatever the line termination character happens to be.

[Bob_Schor]

You are using Express VIs (which limit what you can do) and have chosen to write a text-base LabVIEW Measurement (.lvm) file that has a specific form/format defined by NI.

If, instead, you do your own file I/O, you can write the file in whatever format you desire.  If you choose wisely, you can come up with something that is (a) easy for a human to read (which means text-based or perhaps an .xlsx file opened in Excel), (b) easy to parse, and (c) easy to maintain and modify.  It will be slightly "non-standard", but it is not hard to develop and will do what you want, not what you have to do.

Bob Schor

[antoniosaninge]

Thanks a lot minions, I have used a similar programm and it solved my problem!