Copying Data to File

Copying pen data to Microsoft Excel allows you to manipulate the data using spreadsheet application capabilities.

Notes

• The Time column is an encoded (OLEDATE) double value, which holds the date and time in seconds in local time. When exporting pen data to Excel, change the format of the Time column to dd/mm/yyyy hh:mm:ss so that the time is displayed correctly. Because the OLEDATE data type excludes milliseconds, a separate column is provided, which exports the millisecond component for each timestamp.
• The results exported are in Unicode format. use Excel 2000 and later, which support this format.

1. Select the pen(s) you want to copy data for.
2. Click Copy to File. The Save As dialog box appears.
3. Enter a filename and click Save. The data is exported in a delimited format.
4. Open the file you just created, and complete the Text Import Wizard.

Published June 2018