CellsHelper Class
Provides helper functions.
Inheritance Hierarchy
SystemObject
  Aspose.CellsCellsHelper

Namespace: Aspose.Cells
Assembly: Aspose.Cells (in Aspose.Cells.dll) Version: 19.11.0.0 (19.11)
Syntax
public class CellsHelper

The CellsHelper type exposes the following members.

Properties
  NameDescription
Public propertyStatic memberAltStartPath
Gets or sets the alternate startup path, which is referred to by some external formula references.
Public propertyStatic memberCustomImplementationFactory
Gets or sets the factory for creating instances with special implementation.
Public propertyStatic memberDPI
Gets the DPI of the machine.
Public propertyStatic memberFontDir Obsolete.
When generating PDF/XPS, specific font file directory can be set in the property. If it is not set , using %WINDOWS%\fonts by default.
Public propertyStatic memberFontDirs Obsolete.
When generating PDF/XPS, specific font file directories can be set in the property. If it is not set , using %WINDOWS%\fonts by default.
Public propertyStatic memberFontFiles Obsolete.
When generating PDF/XPS, specific font files can be set in the property. Such as "d:\myfonts\myArial.ttf"
Public propertyStatic memberLibraryPath
Gets or sets the library path which is referred to by some external formula references.
Public propertyStatic memberSignificantDigits
Gets and sets the number of significant digits. The default value is 17.
Public propertyStatic memberStartupPath
Gets or sets the startup path, which is referred to by some external formula references.
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 methodStatic memberDetectFileFormat(Stream) Obsolete.
Detects the format type of the file stored in the stream.
Public methodStatic memberDetectFileFormat(String) Obsolete.
Detects the file format type.
Public methodStatic memberDetectLoadFormat(Stream) Obsolete.
Detects the file load format.
Public methodStatic memberDetectLoadFormat(String) Obsolete.
Detects the file load format.
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(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
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodStatic memberGetTextWidth
Get width of text
Public methodGetType
Gets the type of the current instance.
(Inherited from Object.)
Public methodStatic memberGetUsedColors
Gets all used colors in the workbook.
Public methodStatic memberGetVersion
Get the release version.
Public methodStatic memberIsProtectedByRMS(Stream) Obsolete.
Gets whether the file is protected by Microsoft Rights Management Server.
Public methodStatic memberIsProtectedByRMS(String) Obsolete.
Gets whether the file is protected by Microsoft Rights Management Server.
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(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
Returns a string that represents the current object.
(Inherited from Object.)
See Also