Saving data in axcel file

[RoyDaou]

Hi, I want to save the data in an excel file...

In fact,I use a DAQ board and acquire signals from the muscles of a patient.

I want to save in the excel file the patient name, the date and the data that i had measured from the DAQ.

For the values of the DAQ, there are no problems since i am using the "write to speadsheet block"

Any help please. Thank you in advance

[smercurio_fc]

If there are no problems, then what is your question?

Are you asking how to add a header? Since you are using Write To Spreadsheet File, simply call the VI before your loop, and wire in a 1D array of strings, or a 2D array of strings, that corresponds to your header (depending on how you want to format the header). Inside the loop just call the Write to Spreadsheet File with the "append" input set to true.

[roy_daou]

Thank you for your reply.

The problem is that i can't save the sting of characters of the patient name, the date and the time... I couldn't integrate them using the "write to speadsheet block"... There was a problem with the data type. 

Thank you again

[nyc_(is_out_of_here)]

Convert to strings.

[lacVIEW]

Are you trying to save the patient information as part of the file name or as part of the spreadsheet?

[roy_daou]

As part of the spreadsheet...

[nyc_(is_out_of_here)]

patient name is text so what exactly is the problem???

[smercurio_fc]

Well, if I have a number and I need to call a function that takes in a string, I clearly need to convert the number to a string, right? Well, you obviously need to do the same thing. You need to format the date to a string. There are plenty of string functions that you can use. You can use the generic Format Into String function, or the datetime-specific ones in the Time palette. Look at the LabVIEW Help for these functions. They provide examples of the strings you get.

[roy_daou]

I don't know how to save the patient name and hte data in a single spreadsheet

[smercurio_fc]

Did you read my original response?