Copying pen data to Microsoft Excel allows you to
manipulate the data using spreadsheet application capabilities.
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
To copy data to file:
Select the pen(s) you want to
copy data for.
Click Copy to
File. The Save As dialog box appears.
Enter a filename and click
Save. The data is exported in a delimited
Open the file you just created,
and complete the Text Import Wizard.