Microsoft® excel: importing/exporting, Microsoft, Excel: importing/exporting – Rockwell Automation 57RF RFID ICODE Handheld Interface User Manual User Manual
Page 92
92
Rockwell Automation Publication 57RF-UM001A-EN-P - September 2011
Chapter 7
Microsoft
®
Excel:
Importing/Exporting
This section assumes that an ActiveSync connection has been made between the
PC and the handheld device. If not, please read the
section on
for instructions on how to set up ActiveSync.
This example uses Microsoft Excel 2007. The sequence may differ slightly
depending on the Excel version used and the configuration of the PC.
Open the RFID software on the handheld device. Go to the Read tab under
Device>Settings
and check the Single read to file box. Specify file name as
“testfile”.
Enter “0” as the Start byte, “4” as the Length, and “Hex” as the Mode. Perform a
single read to file. (See
Single Tag Read to File on page 76
section for more
details.) The data from the tag will populate on the screen and simultaneously be
saved to a text file.
Open the ActiveSync window on the PC and click on Explore.
Navigate to the \SystemCF\RFID ICODE\Data folder. Copy the file
“testfile1.txt” to the desktop of the PC. Start Excel on the PC.
Drag and drop the “testfile1.txt” icon from the desktop to the Excel window.