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.

id-1187082