how to save data into the excel sheet each time when i run my VI

[swathi.1356016@srec.ac.in]

i need to save the data that i obtained in an excel sheet(same sheet) for running my Vi many times.

[Bob_Schor]

That's fairly simple.  The details depend on how you are interacting with Excel, easily deduced by seeing some code.  Please include a Snippet of the code that relates to writing to Excel.

Bob Schor

[swathi.1356016@srec.ac.in]

the 3 values that i obtain in this VI should be saved to a single excel sheet for many number of times as i run my VI.

[Bob_Schor]

Is that really a Snippet?  [Did you go to the Edit Menu and choose "Save Selected as Snippet"?]

You don't show saving the output, but you do show opening Excel using New Report.  If you want to append (or overwrite, your choice) data to an existing (or newly-created) Excel Workbook, wire the name of the Workbook to the "Template" input of New Report.  Note that when you do this, you will need to take into account the data that are already there.  If you are doing this in a loop, you can save the current "Next Row" (initially 0) in a Shift Register and update it as you write.

My preference in writing Tables using the Report Generation Toolkit is not to use Append Table (as you have done), but to use the Excel Easy Table VI from the Excel Specific sub-Palette.  Among other things, it has two outputs that simplify placing the next sub-table to the right of the previous table or below it.  In addition, in the Excel General sub-Palette, there is Excel Get Last Row, useful if you are re-opening an existing Workbook and want to add rows "at the end".

Bob Schor

[natasftw]

He's using a stacked dequence structure.  It's going to hide a lot of the details and looking at what he has so far, has absolutely zero purpose. 

If you're going to use awkward programming practices that hide what you're doing, you'll want to attach the actual VI so we can try to figure out what you're doing.

[nyc_(is_out_of_here)]

---

@natasftw wrote:

He's using a stacked dequence structure.  It's going to hide a lot of the details and looking at what he has so far, has absolutely zero purpose. 

If you're going to use awkward programming practices that hide what you're doing, you'll want to attach the actual VI so we can try to figure out what you're doing.

---

This post is a rehash of his question from a month ago.

http://forums.ni.com/t5/LabVIEW/how-to-save-array-of-data-8000-numeric-values-generated-using/m-p/31...

[RavensFan]

Look at:

https://decibel.ni.com/content/docs/DOC-2283

[RavensFan]

Ignore the last message.  It was meant for a different thread.

[Bob_Schor]

We are still waiting to see some code (not a picture of code, but either a VI or a Snippet created from the Edit menu) of what you are currently doing.  To paraphrase a line from "Field of Dreams", "Post it, and They will Comment".

 

Bob Schor

[Munna232]

Something like this??