GoFiler Legato Script Reference   Legato v 1.5d Application v 5.25a

Table of Contents	< < Previous	Next >>

 

Chapter Eight — Data Functions (continued)

8.6.8 Workbooks

Programmers can group sheets together into a workbook and save the workbook in XDS format or alternatively open an XDS as a workbook and extract specific sheets or information table data.

For reading, a workbook is opened and mapped. The actual data sheets are not loaded until a sheet handle is requested.

For writing, the object allows data sheets to be added and then written to a file. Generally it is a good idea to name all the sheets and the names should be unique.

Excel workbook export is also supported depending on the implementation platform.

The current implementation does not allow for an existing workbook to be opened and edited. The open and create actions should be considered separate groups of actions.

8.6.9 Workbooks Functions

Reading Workbooks

WorkbookGetSheet — Returns a data sheet object handle for a workbook sheet.

WorkbookOpen — Opens a workbook from a specified file or URL.

WorkbookGetInfoTable — Returns any globally named data (info table) from workbook.

WorkbookGetSheetCount — Returns the number of sheets within the workbook.

Creating Workbooks

WorkbookAddSheet — Adds a data sheet to a workbook.

WorkbookCreate — Creates a Workbook Object for XDS export.

WorkbookExport — Exports a workbook as an XDS file.

See also:

DataSheetEnumerateSheets — Returns an index to the named sheets and properties in a workbook.

Page revised 2024-12-13

 

Table of Contents	< < Previous	Next >>

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.