
167
Operation of the Software
Power Quality Recorder SICAM Q80 7KG8080, System manual
E50417-H1076-C420-A2, Release 12.01.2015
Defining ASCII export templates / Preview
The effect of the currently valid settings is demonstrated by applying them in a preview based on already provided
sample data sets.
ASCII export template definition dialog / Preview
Thus, this provides help in predicting the results of the settings you make.
6.3.3.2
Excel (XLS)-Format
6.3.3.2.1 Overview
This functionality is only available to FAMOS if Microsoft ® Excel is installed on the same system. The program
versions Excel 95 to Excel 2007 are supported.
XLS-format is the default file format for the widely circulated spreadsheet program Microsoft ® Excel. If Excel is
installed parallel to FAMOS, XLS-files can be exported by FAMOS directly. For this purpose, Excel is remotely
controlled by a mechanism called "OLE-Automation". Excel is started in the background, advised to receive the data
from FAMOS and to store the file and is finally closed again.
Constraints
Excel can only administer a limited number of data sets of limited length. The maximum number of rows
(=maximum length of a data set)
is limited to 65536 values
(Excel 95: 16384 values). The
maximum
number of columns is 256
(= number of data sets which can be transferred).
Only one table per XLS-file can be exported.
Only data sets (not text variables) can be exported.
Note also that there are different versions of the XLS-format. Excel 95, for instance, cannot read XLS-files
saved in Excel 2000 format.
When saving structured data types (groups, event-based and segmented waveforms, 2-component data sets), the
individual parts (channels of the group, events, segments, components) are extracted and written out each in its own
column.
Data export in XLS-format comes with many configuration options. Naturally, it is possible to save multiple data sets
together in a table with multiple columns. A table header, column titles and scaling column(s) all can also be defined.
Such a format definition is called an XLS export template. A included template can be changed by the user with the
help of a dialog.
Technically, there is no difference between an XLS export template and an ASCII export template. Only the number of
settings available is different, since some specifications needed for ASCII-export are not necessary for Excel-export.