ExcelSheet class

From Catglobe Wiki
Revision as of 08:03, 2 July 2020 by Administrator (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

ExcelSheet



An excel sheet

Parent class

Inherits from object

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", int 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
  • (From object) 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
  • (From object) TypeInformation TypeInformation { get; } - Get information about this class.