info

Returns properties of a spreadsheet as a struct.

info( workbook )

##Required arguments

• workbook spreadsheet object

##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 );