View Single Post
  #3   Spotlight this post!  
Unread 07-02-2014, 22:46
Joe Ross's Avatar Unsung FIRST Hero
Joe Ross Joe Ross is offline
Registered User
FRC #0330 (Beachbots)
Team Role: Engineer
 
Join Date: Jun 2001
Rookie Year: 1997
Location: Los Angeles, CA
Posts: 8,563
Joe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond repute
Re: Reading an Excel Spreadsheet on the CRIO

Quote:
Originally Posted by Pault View Post
I am currently working on creating an autonomous scripting program for my team, and I have been having some trouble figuring out how to read the spreadsheet. I have been looking at team 1640's 2013 code to try and figure it out, but I can't seem to get access to the file. I believe that my problem is that the file is located on my computer, and I am trying to read it from the CRIO. If it helps anyone to know: even if I leave the file path unwired, LabVIEW will still give me an error instead of opening the file dialog box.
The cRIO can't open a dialog box on your computer. You need to ftp the file to the cRIO, so that it exists on the cRIO.


Quote:
Originally Posted by wireties View Post
Why use a spreadsheet format? A simple text file would be much easier - something like this for 2-ball autonomous:

BEGIN
MOVE <X> <Y> <speed>
DELAY <time>
STOP
LAUNCH
MOVE <X> <Y> <speed>
DELAY <time>
STOP
PICKUP
MOVE <X> <Y> <speed>
DELAY <time>
STOP
LAUNCH
END


Our team uses something like this. It is much easier to parse.
The following is a spreadsheet format and is at least as easy to parse, if not easier.


Code:
BEGIN,,,,
MOVE, <X>, <Y>, <speed>,
DELAY, <time>,,,
STOP,,,,
LAUNCH,,,,
MOVE, <X>, <Y>, <speed>,
DELAY, <time>,
STOP,,,,
PICKUP,,,,
MOVE, <X>, <Y>, <speed>,
DELAY, <time>,,,
STOP,,,,
LAUNCH,,,,
END,,,,
Reply With Quote