Formatting data for writing to spreadsheet

[RChoudhary]

i am programming some instruments to do automation, now i want to write the data of every instrument e.g values i am programming and the values i am reading back , i want to write all this data to excel sheet , what is required is heading( name of every instrument) should come to the 1st row, and data corresponding to every instrument should come below that instrument heading only.

i htried to do this but data is not coming as expected 

below i am attaching the vi, i am attaching the whole project because there are lotsubvi's, please open the Main new vi in front end folder, it contains the code 

[kausreloaded]

Use TDMS file format It's a Lot better option.Read the attached links.This might help you.

https://www.ni.com/en/support/documentation/supplemental/07/tdms-file-format-internal-structure.html

[Ranjeet_Singh]

Run the VI and let me know whether this helps you.

[RChoudhary]

Thanks kasureloaded and Ranjeet singh for the reply,

Kasureloaded

i will study this TDMS format and will try to implement this in the program,

Ranjeet Singh

i am not getting what is ther location of the file that is getting formed 

[RChoudhary]

Ranjeet singh,

i got it i need to give path at template location. 

[Ranjeet_Singh]

The excel is not saved anywhere, you need to store it...It can be implented in another way.Just play with boolean at second last VIs used there

[RChoudhary]

Do i need to add one ,more vi to save data to file i tried by changing those boolean values but nothing is happpening

[Ranjeet_Singh]

That boolean will only change the excel window behavior. 

What else you are looking for Ritu?

[RChoudhary]

i want to save that file to a prticular location and i am not getting how to do thois

[Ranjeet_Singh]

Then the problem is old data will be replaced with new one..this is what you want?