ExcelSheet class

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

string filename = "abc";
bool isTemp = true;
ExcelSheet es = new ExcelSheet(filename, isTemp);
string sheet1 = es.SheetNames.First();
array headers = es.ToHeaders();
array data = es.ToArray(sheet1, 1);
ImportManager im = new ImportManager(headers, data, ...);
Catglobe.File.Delete(filename, isTemp);