12-08-2010 12:39 PM
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
12-08-2010 03:13 PM
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
12-08-2010 03:21 PM
To export to Excel, simply right click and look at the 'Export' options.
12-08-2010 03:30 PM
@Dennis Knutson wrote:
To export to Excel, simply right click and look at the 'Export' options.
Oh to have a new enough version.... ![]()
12-08-2010 04:11 PM
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.