View Single Post
  #8   Spotlight this post!  
Unread 08-02-2014, 02:04
wt200999's Avatar
wt200999 wt200999 is offline
Texas Instruments
AKA: Will Toth
FRC #3005 (Robochargers)
Team Role: Mentor
 
Join Date: Mar 2006
Rookie Year: 2004
Location: Dallas, Texas
Posts: 323
wt200999 has much to be proud ofwt200999 has much to be proud ofwt200999 has much to be proud ofwt200999 has much to be proud ofwt200999 has much to be proud ofwt200999 has much to be proud ofwt200999 has much to be proud ofwt200999 has much to be proud ofwt200999 has much to be proud of
Send a message via MSN to wt200999
Re: Reading an Excel Spreadsheet on the CRIO

To transfer files to the cRio we use FTP. In Windows 7 you can open any file browser and type ftp:\\10.xx.yy.2 into your browser when connected to the robot to upload files.

We use the following directory to store our scripts on the cRIO:

/ni-rt/LabVIEW Data/Scripts/

To read this directory we use the default data directory VI and a build path to list all the files and parse each one:

Click image for larger version

Name:	Loading Scripts.PNG
Views:	51
Size:	2.1 KB
ID:	16155

For the format we use, we basically compromised between what wireties and Joe Ross have said.

Our scripts look like what wireties showed (without the BEGIN and END)

Example:

Code:
MOVE <left %> <right %> <time>
TURN_ANGLE <angle>
DRIVE_DISTANCE <inches> 
SHOOT_ON_HOT
However we parse it using the spreadsheet parse function, with SPACE as a deliminator instead of comma

Name:  spreadsheet.PNG
Views: 464
Size:  1.1 KB
__________________
Programming in LabVIEW? Try VI Snippets!

FIRST LEGO League 2004 - 2005
FRC Team 870 Student 2006 - 2009
FRC Team 3005 Mentor 2013 -
Reply With Quote