The ExcelHelper type exposes the following members.

Constructors

  NameDescription
ExcelHelper
This class has a single constructor used to setup the needed Microsoft.Office.Interop.Excel.Application object for use.

Methods

  NameDescription
Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Finalize
Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
(Inherited from Object.)
GetCellValue
This method returns the value of a particular cell based on the row and column for a particular worksheet.
GetExcelColumnLetter
This method gets the appropriate "A" thru "ZZZ" column header for Excel based on a passed in long data type.
GetExcelColumnSet
This method returns the ("A:ZZZ") part of the Range("A:ZZZ") column interface.
GetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
GetType
Gets the Type of the current instance.
(Inherited from Object.)
GetWorksheet
This method retrieves a specific worksheet by name.
IsExistingWorksheetNameOverloaded.
MakeWorksheetNameSafe
This method makes a string into a worksheet safe name.
MemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
NewWorksheet
This method creates a new worksheet with the name specified.
PutCellValue
ToString
Returns a String that represents the current Object.
(Inherited from Object.)

Properties

  NameDescription
ExcelApplication
This property is set to the active application the class executes methods against.

See Also