  |
GoFiler Legato Script Reference
Legato v 1.5d Application v 5.25a
|
| Table of Contents | < < Previous | Next >> |
Chapter Eight — Data Functions (continued)
DataSheetEnumerateNamedCells Function
Overview
The DataSheetEnumerateNamedCells function scans the object and returns a table of cell names and locations.
Syntax/Parameters
Syntax
string[][] = DataSheetEnumerateNamedCells ( handle hSheet );
Parameters
hSheet
A handle to a Data Sheet Object.
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”, “Column” and “Cell”. The row and column values are zero-based string representation of the position. The cell value is a cell address such as “B17”.
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
Legato IDE, Legato Basic
Page revised 2024-12-13
| Table of Contents | < < Previous | Next >> |
© 2012-2024 Novaworks, LLC. All rights reserved worldwide. Unauthorized use, duplication or transmission prohibited by law. Portions of the software are protected by US Patents 10,095,672, 10,706,221 and 11,210,456. GoFiler™ and Legato™ are trademarks of Novaworks, LLC. EDGAR® is a federally registered trademark of the U.S. Securities and Exchange Commission. Novaworks is not affiliated with or approved by the U.S. Securities and Exchange Commission. All other trademarks are property of their respective owners. Use of the features specified in this language are subject to terms, conditions and limitations of the Software License Agreement.