Difference between revisions of "ExcelSheet class"
(Created page with "{{CGscriptClass_Template |Name=<nowiki>ExcelSheet</nowiki> |Description=<nowiki>An excel sheet</nowiki> |Constructors= {{CGscriptConstructors_Template|Parameters= {{CGscriptPa...") |
(No difference)
|
Revision as of 05:40, 7 April 2015
ExcelSheet
An excel sheet
Constructors
- (string filename "Name of the file", bool isTemp "Is the file temporary") - Load a file from FileNamespace
Methods
- array ToArray(string sheetName "The sheet to convert", number fromrow "Skip number of rows") - Convert the sheet to an array of equal sized arrays
- array ToHeaders(string sheetName "The sheet to convert") - Convert the first row to array of strings
- string ToString() - The string representation of the object.
Properties
- string ObjectTypeName { get; } - The name of the type of object.
- array SheetNames { get; } - Get list of sheets in the excel file
- TypeInformation TypeInformation { get; } - Get information about this class.