Describe the specified Excel worksheet.

Required Parameters

• sheet: The name of the Excel worksheet.

Optional Parameters

• version: The version of Excel you are using. The allowed values are ‘AUTO, 95, 97-2003, 2007’. The default value is ‘AUTO’.
• file: The path to the Excel workbook.
• handle: The handle for the Excel file.
• headerlocation: Location of the column headers. The default value is ‘NONE’.
• headernames: Comma-delimited list of column or row headers that you want to use (for example, firstName, lastName).
• recalculate: If true, recalculate the formulas and save the results before returning values. The default value is ‘true’.
• Ignorecalcerror: If ignorecalcerror is set to True any errors that occur due to formula calculation will be ignored. If this happens the formula result may be unreliable but other data will be accurate. The default value is ‘false’.
• logfile: The log file used to log any errors that occurred during the calculation.
• typedetectionscheme: The scheme to detect the data type.
• rowScandepth: The row scan depth.

Output Attributes

• *: Dependent on the content of the sheet and the range specified.
• meta:row: The index of the row in the Excel document.