Import X and Y coordinates from spreadsheet and make motor movements

[JackBrown]

Hello,

        As you  can see in attached vi file, I have to manually type in X and Y coordinate points inside an array to make a sequence of motor movements. It looks inappropriate when we have 100 data points or may be 1000 points and fill in all of them manually. Our intention is that we use other spreadsheet files such as excel or notepad(as in attached file) where we define our coordinates and import that data in LabVIEW by just calling the spreadsheet to move motors accordingly. I have tried some of the functions in LabVIEW. However, I could not manage to do with the knowledge that I have. Could you please help me? I appreciate it.

Best Regards,

Jack

[KateB · Accepted solution]

1. In Excel, save the file as Text (Tab delimited).

2. You can easily read it with Programming>>File I/O>>Read from Spreadsheet File.vi