Chapter Eight --o Data Functions

Legato

Legato

GoFiler Legato Script Reference

Legato v 1.5b

Application v 5.24b

Table of Contents	< < Previous	Next >>

Chapter Eight — Data Functions

Chapter Contents

8.1 Introduction to Data Support

8.1.3 Text Tools

8.1.4 Array Tools

8.1.6 Data Sheet

8.2 Comma Separated Values

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.2 Functions

FormattedTextToArray Function

8.4 Array Data Tools

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

DataSheetAddToWorkbook Function

DataSheetCreateWorkbook Function

DataSheetExportWorkbook 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.2 Item Name

8.7.3 Functions

JSONLoad Function

JSONGetInteger Function

JSONGetObjectIndex Function

JSONGetObjectKeyName Function

JSONGetString Function

JSONGetType Function

JSONGetValue Function

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.