auto_LoadMatrixDataset

auto_LoadMatrixDataset loads a data matrix from a file and creates a 3D dataset.

hData = auto_LoadMatrixDataset(ssDiagram, ssFileName)

Return Value

Returnwert

hData is a handle of the new dataset (see example).

Parameters

Parameter

ssDiagram

ssDiagram is the name of the diagram in which the dataset should be

displayed. If an empty name is given, the dataset will not be added to any diagram. In this case the dataset must be added to a diagram using LayerAddDataset.

ssFileName

ssfileName is the name of a data file containing the matrix. The file can be a text of an Excel file. In case of an Excel file the sheet name can be added to the file name in square brackets. See example. I no sheet name is specified the matrix will be loaded from the first sheet.

Comment

The matrix format is specified here: File=>More File Functions=>Load 3D Data Matrix

Example

hPage = auto_LoadTemplate("c:/mytemplate.ipw");
// Sheet2 is the sheet name.
hData = auto_LoadMatrixDataset("Diagramm 1", "c:/mymatrix.xls [Sheet2]");
if (hData != 0) {
    hLayer = GetParent(hData);
        LayerAutoScale(hLayer);
}

History

Version	Description
R2011.13	New.

See also

Overview Automation, auto_LoadTemplate, auto_SetTemplate, auto_LoadDataset, LayerAddDataset, GetParent, File=>More File Functions=>Load 3D Data Matrix

_id-1187082