Name
xlsx.GetObjectType -- get XLSX document object type
Synopsis
type = xlsx.GetObjectType()
Function
This function returns the object type used by XLSX documents opened using the xlsx.Open() or xlsx.Create() functions. You can then use this object type with functions from Hollywood's object library such as GetAttribute(), SetObjectData(), GetObjectData(), etc.

In particular, Hollywood's GetAttribute() function may be used to query certain properties of XLSX documents. The following attributes are currently supported by GetAttribute() for XLSX documents:

#XLSXATTRSHEETS:
Returns the number of sheets in the XLSX document.

Inputs
none

Results
type
internal XLSX document type for use with Hollywood's object library
Example
xlsx.Open(1, "test.xlsx")
XLSX_DOCUMENT = xlsx.GetObjectType()
numsheets = GetAttribute(XLSX_DOCUMENT, 1, #XLSXATTRSHEETS)
The code above opens test.xlsx and queries the number of sheets in the document via GetAttribute().

Show TOC