Legato
Legato

GoFiler Legato Script Reference

 

Legato v 1.5d

Application v 5.25a

  

 

Chapter EighteenDataView Integration (continued)

DataViewEnumerateNamedCells Function

Overview

The DataViewEnumerateNamedCells function scans the object and returns a table of cell names and locations.

Syntax/Parameters

Syntax

string[][] = DataViewEnumerateNamedCells ( handle object );

Parameters

object

A handle either to a Data View Object or to a window that employs Data View.

Return Value

Returns a string table with a row for each named position or an empty array on failure. Use the GetLastError and GetLastErrorMessage to retrieve further information on error. Enumerating a sheet with no named cells will return an error.

Remarks

The return data is a two-dimensional array with a row entry for each cell and three columns containing the keyed names “Name”, “Row” and “Column”. The row and column values are zero-based string representation of the position.

If the sheet does not contain a named cells, an empty array will be returned with that last error being set as ERROR_EOD.

Related Functions

Platform Support

Go13, Go16, GoFiler Complete, GoFiler Corporate, GoFiler, GoFiler Lite, GoXBRL