Legato
Legato

GoFiler Legato Script Reference

 

Legato v 1.5d

Application v 5.25a

  

 

Chapter Eight — Data Functions

Chapter Contents

8.1 Introduction to Data Support
8.1.1 Overview
8.1.2 CSV Data
8.1.3 Text Tools
8.1.4 Array Tools
8.1.5 ODBC/SQL
8.1.6 Data Sheet
8.2 Comma Separated Values
8.2.1 Overview
8.2.2 The CSV Object
8.2.3 Functions
CSVAppendField Function
CSVArrayToString Function
CSVCreate Function
CSVGetFieldCount Function
CSVGetFields Function
CSVGetNumericField Function
CSVGetStringField Function
CSVIsLastField Function
CSVIsLastRecord Function
CSVReadTable Function
CSVReset Function
CSVSetExportFlags Function
CSVSetRecord Function
CSVTableToString Function
CSVWriteRecord Function
CSVWriteTable Function
8.3 Text Data Tools
8.3.1 Overview
8.3.2 Functions
FormattedTextToArray Function
8.4 Array Data Tools
8.4.1 Overview
8.4.2 Functions
ArrayToParameters Function
BinarySearchList Function
BinarySearchTable Function
DeleteEmptyTableRows Function
DeleteListItem Function
DeleteTableRow Function
ExplodeString Function
ImplodeArray Function
FindInList Function
FindInTable Function
HasData Function
HasColumnData Function
HasRowData Function
HasTableData Function
InsertListItem Function
InsertTableRow Function
IsEmpty Function
IsListEmpty Function
IsColumnEmpty Function
IsRowEmpty Function
IsTableEmpty Function
ListDifference Function
ListIntersection Function
ListIsSubset Function
ListUnion Function
ParametersToArray Function
ParametersToTable Function
SortList Function
SortTable Function
TableDeleteDuplicates Function
TableToParameters Function
TableToText Function
8.5 Open Database Connectivity (ODBC) Tools
8.5.1 Overview
8.5.2 Using ODBC
8.5.3 ODBC Objects
8.5.4 Data Types
8.5.5 ODBC Errors
8.5.6 Functions
ODBCConnect Function
ODBCFetchAll Function
ODBCFetchArray Function
ODBCFetchBinary Function
ODBCFetchColumnName Function
ODBCFetchColumnNames Function
ODBCFetchData Function
ODBCGetColumnCount Function
ODBCGetRowCount Function
ODBCHasData Function
ODBCNextRow Function
ODBCQuery Function
8.6 Data Sheet
8.6.1 Overview
8.6.2 Operation
8.6.3 Rows and Columns
8.6.4 Cells and Cell Data
8.6.5 Cell Style
8.6.6 Edit Management
8.6.7 Data Sheet Object Functions
DataSheetCreate Function
DataSheetEnumerateSheets Function
DataSheetExport Function
DataSheetExportRegion Function
DataSheetGetObject Function
DataSheetGetSheetName Function
DataSheetImport Function
DataSheetOpen Function
DataSheetSetSheetName Function
DataSheetSetSheetSize Function
DataSheetToTable Function
8.6.8 Workbooks
8.6.9 Workbooks Functions
WorkbookAddSheet Function
WorkbookCreate Function
WorkbookExport Function
WorkbookGetSheet Function
WorkbookOpen Function
WorkbookGetInfoTable Function
WorkbookGetSheetCount Function
8.6.10 Default Units
8.6.11 Measuring Functions
DataSheetGetColumnWidth Function
DataSheetGetDefaultColumnWidth Function
DataSheetGetDefaultRowHeight Function
DataSheetGetRowHeight Function
DataSheetGetSheetDepth Function
DataSheetGetSheetWidth Function
DataSheetMeasureSheet Function
DataSheetSetDefaultColumnWidth Function
DataSheetSetDefaultRowHeight Function
8.6.12 Edit Management Functions
DataSheetActionClose Function
DataSheetActionOpen Function
DataSheetEnableTransactions Function
DataSheetIsActionOpen Function
8.6.13 Style Functions
DataSheetGetCellStyle Function
DataSheetGetDefaultFont Function
DataSheetGetStyle Function
DataSheetGetStyleCount Function
DataSheetGetStyleProps Function
DataSheetSetStyle Function
8.6.14 Row Functions
DataSheetGetRowCount Function
DataSheetGetRowDataWord Function
DataSheetGetRowProps Function
DataSheetHasRowArray Function
DataSheetIsRowDisabled Function
DataSheetIsRowEmpty Function
DataSheetIsRowHidden Function
DataSheetRowDelete Function
DataSheetRowInsert Function
DataSheetSetRowDataWord Function
DataSheetSetRowHeight Function
8.6.15 Column Functions
DataSheetColumnDelete Function
DataSheetColumnInsert Function
DataSheetGetColumnCount Function
DataSheetGetColumnProps Function
DataSheetHasColumnArray Function
DataSheetIsColumnDisabled Function
DataSheetIsColumnEmpty Function
DataSheetIsColumnHidden Function
DataSheetSetColumnWidth Function
8.6.16 Cell Functions
DataSheetEnumerateNamedCells Function
DataSheetFindCellByName Function
DataSheetGetCell Function
DataSheetGetCellAttributes Function
DataSheetGetCellAttributeString Function
DataSheetGetCellName Function
DataSheetGetCellText Function
DataSheetGetCellType Function
DataSheetGetColumnSpan Function
DataSheetIsCellDisabled Function
DataSheetIsCellHidden Function
DataSheetIsCellMerged Function
DataSheetIsCellNull Function
DataSheetIsCellProtected Function
DataSheetIsCellReadOnly Function
DataSheetMergeCells Function
DataSheetSetCellAttributes Function
DataSheetSetCellDisabled Function
DataSheetSetCellHidden Function
DataSheetSetCellProtected Function
DataSheetSetCellReadOnly Function
DataSheetSetCellStyle Function
DataSheetSetCellText Function
DataSheetSetCellTextWrap Function
DataSheetSetCellType Function
8.7 JavaScript Object Notation (JSON)
8.7.1 Overview
8.7.2 Item Name
8.7.3 Access by Direct Index
8.7.4 Functions
JSONLoad Function
JSONGetArrayCount Function
JSONGetFloat Function
JSONGetInteger Function
JSONGetObjectCount Function
JSONGetObjectIndex Function
JSONGetObjectKeyName Function
JSONGetString Function
JSONGetType Function
JSONGetValue Function

 

 

GoFiler Legato Script Reference — Generated on 12/16/2024

© 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.