Software Owner's manual

ManualsBrandsCrystal ManualsSoftwareDataLoggerXP Digital Pressure Gauge

Data Logging with DataLoggerXP  22

XP2i Operation Manual

—

EXCEL TEMPLATES

In order to provide for a exible 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 dierent le types see To Save a File in Excel Format on page 16.

DataLoggerXP uses an existing Excel template le to create a new workbook. This allows any amount of formatting or graphing to be edited beforehand and

stored as a template le. Then, when the Excel workbook is created, the template le is opened and data is copied to the location specied in the Options

dialog box. When selecting the template le directly during the le save process, the new workbook is created with the Excel template using the name of the

template le followed by a number, typically "1." The user must also save the le manually, making any changes to the le name as necessary.

The default template le, dataloggerxp.xlt, is located in the DataLoggerXP program directory, and can be used as

–

is or modied 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 minut

es, 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 rst 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 specied 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 nd and choose the tem-

plate you want to use.

ou can bypass this selection during the save process to choose a dierent template to save your data into. Select the Use Excel Template check box and use the

Browse button to nd and select an alternative template.