LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

export to excel

Hi,

 I want to export values to excel but having problem in doing so. Let me explain it. If I enter the time 11.00 in tha vi " Getting irradiance values for different time", it starts calculating irradiance value from that time tilll I press stop button in vi " Final file for getting module data... Desired time". Now I want to export the four global variable values(Short Circuit current,open circuit voltage,Maximum current ,Maximum voltage) and irradiance to datasheet for the time I ran the vi(for example if i run it for two days).I have tried using write to spreadsheet vi but didn't work.Please help . 

Shankar
0 Kudos
Message 1 of 6
(3,441 Views)
some more information i would like to add...
Download All
0 Kudos
Message 2 of 6
(3,438 Views)

You should indicate that this is related to this thread and this thread and this thread and this thread.

 

Your VIs don't make much sense. The top-level VI that you uploaded, "final file ..." is calling a subVI "Getting irradiance values at different instant of  time3.vi". Note that it has 2 spaces before "time3", but you uploaded a VI that has only one space in its name, leading me to believe you have a different VI, or linking problems. Also, the subVI that you actually did upload has a path control, but you are not feeding any value to the subVI, so it has no file to read. Likewise, the big cluster with all the reading options is not wired, so even if you provided a path, it can't parse the file. I have no idea why you're using a formula node to do a simple subtraction, or why you're using rotate array functions.

 

Also, please do not upload .xlsx files. These are created with Excel 2007, and not everyone has this. Besides, you said you're using the Write to Spreadsheet File VI, so I don't know why you're upload Excel workbooks.

0 Kudos
Message 3 of 6
(3,423 Views)
Hi,I know my program is not sophisticated but if you can suggest something to improve that will be helpful.Yes you are right in place of formula node now I am using substract numeric function.I am attaching snapshot of what I am getting when I am running my vi. "Getting irradiance value vi "is used as subvi in "final file vi". Now I think you may be having an idea of what I am upto. Now I want to export these data for the period of time I ran the program. For example if I start it at 13.20 and run it till 14.20 then I will be able to export 60 values because I ran it for one hour.Hope you got my point.
0 Kudos
Message 4 of 6
(3,416 Views)

What about writing one row at a time as you acquire the data? Such as:

 

WriteOneRow.png

I didn't look at your code but thought I'd take a stab based on your description of what you're attempting.
Message Edited by Bill@NGC on 07-19-2009 05:19 PM
0 Kudos
Message 5 of 6
(3,409 Views)

shan2036 wrote:
I am attaching snapshot of what I am getting when I am running my vi. "Getting irradiance value vi "is used as subvi in "final file vi".

You're not understanding my point about subVIs. Do the following:

  1. Close all VIs.
  2. Open the "final file..." VI. DO NOT OPEN ANY OTHER VIs. 
  3. You should have only ONE VI open - the "final file..." VI.
  4. Switch to the block diagram of the "final file..." VI. Place a probe on either of the orange wires coming out of the "Getting irradiance..." VI. DO NOT OPEN THAT SUBVI. Leave the block diagram of the "final file..." VI open.
  5. Set the front panel controls of the "final file..." VI to the appropriate values (i.e., for your big cluster and for the filepath). DO NOT OPEN THE "Getting irradiance ..." VI.
  6. Run the "final file..." VI.
What does the probe show? An empty array. Why? Because the "Getting irradiance ..." VI is trying to read the file the same way as the top-level VI, but it can't because the cluster and filepath controls have not been set. Frankly, there is no reason for the "Getting irradiance ..." VI to be reading the file again since the "final file" has already done so. If you still want that subVI then you should pass in the array of values that was read in by the "final file" VI.
0 Kudos
Message 6 of 6
(3,372 Views)