Crystal DataLoggerXP Digital Pressure Gauge Software - Manual (Page 24)

Data Logging with DataLoggerXP  22
XP2i Operation Manual
—
eXceL teMPLates
In order to provide for a flexible reporting solution, DataLoggerXP is capable of directly interfacing with Microsoft® Excel to paste run data for reporting and
graphing. DataLoggerXP supports Excel 2003, 2007, and 2010. This section assumes some familiarity with Excel.
Note: For information on how to save data to the different file types see to save a file in excel format on page 16.
DataLoggerXP uses an existing Excel template file to create a new workbook. This allows any amount of formatting or graphing to be edited beforehand and
stored as a template file. Then, when the Excel workbook is created, the template file is opened and data is copied to the location specified in the Options
dialog box. When selecting the template file directly during the file save process, the new workbook is created with the Excel template using the name of the
template file followed by a number, typically "1." The user must also save the file manually, making any changes to the file name as necessary.
The default template file, dataloggerxp.xlt, is located in the DataLoggerXP program directory, and can be used as–is or modified to meet the user’s require-
ments. The default template produces a graph with an elapsed seconds time base. Choose one of the other appropriately named templates to graph with a
time base of minutes, hours, or timestamps in DD-MM-YY or MM-DD-YY formatting.
excel Password Protection
It is possible to password protect the Excel workbook by selecting the Password Protect Excel Documents checkbox in the Options dialog box. Only the data
sheet and first sheet of the workbook will be password protected. To protect other sheets, password protect them in the template itself.
data
Data is copied to the location specified in the Options dialog box. The user must provide the sheet, row, and column reference. If the reference is invalid, the
data will not be exported to Excel.
default template file
Set the default template by selecting the Use default template check box in the View-Options dialog box. Use the Browse button to find and choose the tem-
plate you want to use.
You can bypass this selection during the save process to choose a different template to save your data into. Select the Use Excel Template check box and use the
Browse button to find and select an alternative template.