LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Need help with report generation toolkit

Well using your VI, my chart looks also good. But after copy-pasting it into my VI I'm getting this (see attachement). The Diameter should be around 11 while the distance is constantly increasing up to 1 (mm)

0 Kudos
Message 11 of 18
(916 Views)

Ooooh maaan....i've finally got it working. I had to transpose the array before sending it to the Excel Easy Graph VI. I was trying to transpose it before sending it to the Excel Easy Table VI, but it's obvious that it doesn't have to do anything to do with that. Im such a moron :D.

 

What i want to do next, is this: After saving the Data in the excel file, the User should be asked if he wants to do another measurement. If yes, the new data has to be stored in the same file, but a different worksheet. How do I do this?

0 Kudos
Message 12 of 18
(911 Views)

Thats what i meant with the transpose array Smiley Happy

The next steps are quite easy... with the "one button dialog" you can prompt the user and ask him if he want to do a next measurement... and with the "Excel get Worksheet" you can select the active worksheet. 

0 Kudos
Message 13 of 18
(901 Views)

Can you show me an example of how i can jump back in a sequence structure?

0 Kudos
Message 14 of 18
(895 Views)

Just add a While Loop around the sequence you want to repeat. When i look at your programm you should make a state machine out of it, then it will be much easier.

 

untitled.JPG

0 Kudos
Message 15 of 18
(892 Views)

Hello,

 

You can draw a chart or graph in LabVIEW and pass the reference to the excel file as an Image.

I have attached one example please see it. May be it solve your problem.

Thanks and Regards
Himanshu Goyal | LabVIEW Engineer- Power System Automation
Values that steer us ahead: Passion | Innovation | Ambition | Diligence | Teamwork
It Only gets BETTER!!!
0 Kudos
Message 16 of 18
(887 Views)

Well yes, i know, a statemachine would be a better solution for my program. Unfortunately I don't have much time left to finish the program, so reprogramming the whole thing is not an option. By the way thanks for the screenshot, but will the data be saved in the same excel file? I tried it with a for-loop by asking how many measurements the user wants to do, but instead of writing the data into a new worksheet, the programm opened as many excel files as the user defined how much measurements he wants to do. Additionally the data besides the first excel-file was jibberish.  

0 Kudos
Message 17 of 18
(883 Views)

That's because you haven't specified a Excel File on the New Report.vi (template input).

 

You have 2 oportunities:

 

1. You can specifie an Excel File

 

2. Only Open and Cloe the Excel file one Time. Open it, then make all the measurements and the Cloe it. Look at the screenshot

 

untitled.JPG

0 Kudos
Message 18 of 18
(878 Views)