save values from subvi into spreadsheet

[632]

Hi everyone,

I am new to LabView and I have a problem that has been on for days now..

I am creating a quiz where each questions will be in a VI itself. The main VI will be calling the subVI into the subpanel when it is called. My problem appears to be at the "results" part of the quiz. I do know the use of "Save to spreadsheet.vi".

I have tried putting the save to spreadsheet.vi in the subvi but it does not save the data until the "stop" button in the subvi is pressed. Clicking the stop button is not a problem. The problem is that once I pressed the stop button, I cannot call out the next question.

I have also tried to put the "save to spreadsheet.vi" at my main vi. But the whole VI does not run at all.

[g_e_m_i_n_i]

I think what you need is an event structure. Make a write to file button, then set the event strucutre to write the file when your button is pressed. This will stop the program from stopping.

In the example I attached, I didnt name the buttons (which i should have), but when each button gets pressed, the event structe will happen. Similar to when your write to file button gets pressed. 

Good luck. 

[MoReese]

One problem is you are using tunnels on the while loop in your sub-vi.  You should enable auto-indexing to capture all the data from every iteration; otherwise, you will only see the last data element. 

Edit: Perhaps your intentions is to capture on data set?  In that case, never mind.

[MoReese]

How did you create these .png files?  Did you create a Vi snippet?  I can't load your pics onto the BD.  Can you post your code?

[ben64]

Also add a Wait function in Q1 loop so you don't monopolize the CPU.

Ben64

[632]

very sorry for the late reply.

the attached is my VI. i did not use a labview tool to take the picture.

Another problem i realise was that when the back button is pressed, the vi is "refreshed" the value that was previously keyed in was gone.

[632]

ic... thanks for your input... i will try to add the event structure into my "questions" and get back to you (:

[MoReese]

I suggest down-converting your code to 8.x.  You may get more help because more folks will be able to access your VIs.

[632]

oh... i have solved my problems already... although i think i need some activex thingy to save it to excel...

I inserted another case so as to save into spreadsheet. thanks everyone for helping me (:

[danil33]

If you solved your issue please post your solved VIs

I think it will be informative for others also