CellsHelper Class
Contents
[
Hide
]CellsHelper class
Provides helper functions.
type CellsHelper struct {
ptr unsafe.Pointer
}
Constructors
| Method | Description |
|---|
Methods
| Method | Description |
|---|---|
| CellsHelper_GetSignificantDigits | Gets and sets the number of significant digits.The default value is 17. |
| CellsHelper_SetSignificantDigits | Gets and sets the number of significant digits.The default value is 17. |
| CellsHelper_GetDPI | Gets the DPI of the machine. |
| CellsHelper_SetDPI | Gets the DPI of the machine. |
| CellsHelper_GetTextWidth | Get width of text in unit of points. |
| CellsHelper_GetVersion | Get the release version. |
| CellsHelper_CellNameToIndex | Gets the cell row and column indexes according to its name. |
| CellsHelper_CellIndexToName | Gets cell name according to its row and column indexes. |
| CellsHelper_ColumnIndexToName | Gets column name according to column index. |
| CellsHelper_ColumnNameToIndex | Gets column index according to column name. |
| CellsHelper_RowIndexToName | Gets row name according to row index. |
| CellsHelper_RowNameToIndex | Gets row index according to row name. |
| CellsHelper_GetDateTimeFromDouble | Convert the double value to the date time value. |
| CellsHelper_GetDoubleFromDateTime | Convert the date time to double value. |
| CellsHelper_GetStartupPath | Gets or sets the startup path, which is referred to by some external formula references. |
| CellsHelper_SetStartupPath | Gets or sets the startup path, which is referred to by some external formula references. |
| CellsHelper_GetAltStartPath | Gets or sets the alternate startup path, which is referred to by some external formula references. |
| CellsHelper_SetAltStartPath | Gets or sets the alternate startup path, which is referred to by some external formula references. |
| CellsHelper_GetLibraryPath | Gets or sets the library path which is referred to by some external formula references. |
| CellsHelper_SetLibraryPath | Gets or sets the library path which is referred to by some external formula references. |
| CellsHelper_CreateSafeSheetName_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 limitand invalid characters will be replaced with ’ ‘, then return the rebuilt string value. |
| CellsHelper_CreateSafeSheetName_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 limitand invalid characters will be replaced with given character, then return the rebuilt string value. |
| CellsHelper_NeedQuoteInFormula | Indicates whether the name of the sheet should be enclosed in single quotes |
| CellsHelper_IsCloudPlatform | Please set this property True when running on a cloud platform, such as: Azure, AWSLambda, etc, |
| CellsHelper_SetIsCloudPlatform | Please set this property True when running on a cloud platform, such as: Azure, AWSLambda, etc, |