CellsHelper Methods

The CellsHelper type exposes the following members.

Methods
  NameDescription
Public methodStatic memberAddAddInFunction
Add addin function.
Public methodStatic memberCellIndexToName
Gets cell name according to its row and column indexes.
Public methodStatic memberCellNameToIndex
Gets the cell row and column indexes according to its name.
Public methodStatic memberColumnIndexToName
Gets column name according to column index.
Public methodStatic memberColumnNameToIndex
Gets column index according to column name.
Public methodStatic memberConvertA1FormulaToR1C1
Converts A1 formula of the cell to the r1c1 formula.
Public methodStatic memberConvertR1C1FormulaToA1
Converts the r1c1 formula of the cell to A1 formula.
Public methodStatic memberCreateSafeSheetName(String)
Checks given sheet name and create a valid one when needed. If given sheet name conforms to the rules of excel sheet name, then return it. Otherwise string will be truncated if length exceeds the limit and invalid characters will be replaced with ' ', then return the rebuilt string value.
Public methodStatic memberCreateSafeSheetName(String, Char)
Checks given sheet name and create a valid one when needed. If given sheet name conforms to the rules of excel sheet name, then return it. Otherwise string will be truncated if length exceeds the limit and invalid characters will be replaced with given character, then return the rebuilt string value.
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodStatic memberGetDateTimeFromDouble
Convert the double value to the date time value.
Public methodStatic memberGetDoubleFromDateTime
Convert the date time to double value.
Public methodGetHashCode (Inherited from Object.)
Public methodStatic memberGetTextWidth
Get width of text in unit of points.
Public methodGetType (Inherited from Object.)
Public methodStatic memberGetUsedColors
Gets all used colors in the workbook.
Public methodStatic memberGetVersion
Get the release version.
Protected methodMemberwiseClone (Inherited from Object.)
Public methodStatic memberMergeFiles
Merges some large xls files to a xls file.
Public methodStatic memberRowIndexToName
Gets row name according to row index.
Public methodStatic memberRowNameToIndex
Gets row index according to row name.
Public methodToString (Inherited from Object.)
See Also