Craig's Utility Library  4.0 Beta
Utilities.IO.FileFormats.Excel Class Reference

Excel doc helper More...

Inheritance diagram for Utilities.IO.FileFormats.Excel:

Public Member Functions

 Excel ()
 Constructor More...
 
 Excel (string FilePath, string Sheet)
 Constructor More...
 
override string ToString ()
 To string function More...
 

Static Public Member Functions

static Excel Load (string Location, string Sheet)
 Loads an excel doc/sheet More...
 

Protected Member Functions

override Excel InternalLoad (string Location)
 Loads data from the excel doc More...
 
override void LoadFromData (string Data)
 Loads data from the excel doc More...
 
void Parse (string FilePath, string Sheet)
 Parses the file More...
 

Properties

IList< string > ColumnNames [get]
 Names of each column More...
 
string this[int Value, string Name] [get]
 Gets the value based on the row and column name specified More...
 

Detailed Description

Excel doc helper

Definition at line 36 of file Excel.cs.

Constructor & Destructor Documentation

Utilities.IO.FileFormats.Excel.Excel ( )

Constructor

Definition at line 41 of file Excel.cs.

Utilities.IO.FileFormats.Excel.Excel ( string  FilePath,
string  Sheet 
)

Constructor

Parameters
FilePathFilePath
SheetSheet to load

Definition at line 51 of file Excel.cs.

Member Function Documentation

override Excel Utilities.IO.FileFormats.Excel.InternalLoad ( string  Location)
protected

Loads data from the excel doc

Parameters
LocationLocation of the file
Returns
The excel doc

Definition at line 105 of file Excel.cs.

static Excel Utilities.IO.FileFormats.Excel.Load ( string  Location,
string  Sheet 
)
static

Loads an excel doc/sheet

Parameters
LocationLocation of the file to load
SheetSheet of the document to load
Returns
The excel doc

Definition at line 84 of file Excel.cs.

override void Utilities.IO.FileFormats.Excel.LoadFromData ( string  Data)
protected

Loads data from the excel doc

Parameters
DataData to load from

Definition at line 114 of file Excel.cs.

void Utilities.IO.FileFormats.Excel.Parse ( string  FilePath,
string  Sheet 
)
protected

Parses the file

Parameters
FilePathFile path
SheetSheet to parse

Definition at line 124 of file Excel.cs.

override string Utilities.IO.FileFormats.Excel.ToString ( )

To string function

Returns
A string containing the file information

Definition at line 93 of file Excel.cs.

Property Documentation

IList<string> Utilities.IO.FileFormats.Excel.ColumnNames
get

Names of each column

Definition at line 60 of file Excel.cs.

string Utilities.IO.FileFormats.Excel.this[int Value, string Name]
get

Gets the value based on the row and column name specified

Parameters
ValueRow to get
NameColumn name to look for
Returns
The value

Definition at line 69 of file Excel.cs.


The documentation for this class was generated from the following file: