LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

indexing values into from 1 table to another

Hi,

 

I have created a very basic Vi to aid my issue.

 

I want a user to enter values of volume in table 1. And in table two i would like them to appear where it says PVT Point 1, PVT Point 2 etc. i cant get my head around how you would go about indexing the values into table two. All other data in table 2 i would like to be static, thus should always be there.

 

I would also like to be able to Export the entire table as an excel spread sheet once the user is finished. As i said its a very basic example, but someone’s solution should be able to kick start something in my brain for me to develop it further.

 

Many thanks

 

 

0 Kudos
Message 1 of 5
(2,905 Views)

My version of LabVIEW is too early to open your vi, however you can treat the table as if it was an array.

In the attached vi I just pull out a selected value and write it to another table - if I understand your post correctly, this is what you are trying to do.

 

Writing to an excel file can be done using ActiveX but can be a bit of a pain. Writing to a .csv file is far easier and will still open in excel. The write to spreadsheet function is great for this. When the attached vi asks for a filename just make sure you save it as a *.csv file.

 

You get the idea - just modify to suit your particular requirements.

 

Hope that helps

Ian

0 Kudos
Message 2 of 5
(2,886 Views)

To export to Excel, simply right click and look at the 'Export' options.

0 Kudos
Message 3 of 5
(2,881 Views)

 


@Dennis Knutson wrote:

To export to Excel, simply right click and look at the 'Export' options.


Oh to have a new enough version....  Smiley Sad

 

0 Kudos
Message 4 of 5
(2,874 Views)

To add to _Ian_ example you could use "Array Subset" function to pull out a block of data and then paste whole block using "Replace Array Subset" pointed to the upper left conner of the block instead of doing it one cell at a time. 

Omar
0 Kudos
Message 5 of 5
(2,863 Views)