Difference between revisions of "ExcelSheet class"

From Catglobe Wiki
Jump to: navigation, search
(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.


Examples