I am looking for a solution to input data from excel to a table in Labview OR how can I use copy and paste to insert data in a Labview table. Can it be done?
For example - I'm trying to input some data (let's say I have 3 variables a, b, and c) and do some calculations; the output are other values, let's say x, y, z. I would like to have the input from a table and the output should result in a table also. I can further send the output table to excel and I believe Labview has a good example about this. However, Labview does not have any example on how to INPUT a table from excel. Or, let'say you do some calculations in excel and you have a table of 100 lines and 3 columns (a, b, c). It would be annoyng and time consuming to input value by value in an Labview array or table all the cells. Apparently copy and paste does not work for Labview arrays and tables. Or, am I wrong; what would be a good solution to enter more data at one time?
You can use ActiveX methods to get data directly from Excel into LV, but it won't be as simple as reading from the tab delimited text file. Search the example finder (Help>>Find Examples) for Excel and you will find examples for talking to Excel.
I followed your advice. The same thing happens. It appears this is happening only for the excel files that have more than 1 worksheets. Apparently the vi can read only one spreadsheet in a file. What is even more intriguing is that even if I close the application and excel, if I restart the application and or excel and try to reopen the file a message tells me that the file is already ove and if I want to overwrite... It would be neat to make the read-excel-file vi identify the other spreadsheets also and ask you which one you want to read. I believe this would imply adding in the input cluster one more case for spreadsheet but I'm not shure what the other connections will look like. Any way, before doing anything else I'll have to restart my computer to close those background running excel files 🙂