Microsoft® excel: importing/exporting, Microsoft, Excel: importing/exporting – Rockwell Automation 57RF RFID ICODE Handheld Interface User Manual User Manual

Page 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.