info

Jump to bottom Edit New page

Julian Halliwell edited this page Sep 20, 2021 · 7 revisions

Returns properties of a spreadsheet as a struct.

info( workbookOrPath )

Required arguments

a workbook object or the full path to a spreadsheet file

Chainable? Yes but ends the chain.

Properties returned

Author
Category
Comments
CreationDate
LastEdited
LastAuthor
LastSaved
Keywords
Manager
Company
Subject
Title
Sheets (number of sheets)
SheetNames (list of sheet names)
SpreadsheetType (Excel or Excel 2007)

Example

spreadsheet = New spreadsheet();
workbook = spreadsheet.new();
infoToAdd = {
 author="Bob"
 ,category="Testing"
 ,lastAuthor="Anne"
 ,comments="OK"
 ,keywords="test"
 ,manager="Diane"
 ,company="Acme Ltd"
 ,subject="tests"
 ,title="Test figures"
};
spreadsheet.addInfo( workbook,infoToAdd );
info = spreadsheet.info( workbook );