Aspose::Cells::CellsHelper class
Contents
[
Hide
]CellsHelper class
Provides helper functions.
class CellsHelper
Methods
| Method | Description |
|---|---|
| static CellIndexToName(int32_t row, int32_t column) | Gets cell name according to its row and column indexes. |
| static CellNameToIndex(const U16String& cellName, int32_t& row, int32_t& column) | Gets the cell row and column indexes according to its name. |
| static CellNameToIndex(const char16_t* cellName, int32_t& row, int32_t& column) | Gets the cell row and column indexes according to its name. |
| static ColumnIndexToName(int32_t column) | Gets column name according to column index. |
| static ColumnNameToIndex(const U16String& columnName) | Gets column index according to column name. |
| static ColumnNameToIndex(const char16_t* columnName) | Gets column index according to column name. |
| static CreateSafeSheetName(const U16String& nameProposal) | 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. |
| static CreateSafeSheetName(const char16_t* nameProposal) | 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. |
| static CreateSafeSheetName(const U16String& nameProposal, char16_t replaceChar) | 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. |
| static CreateSafeSheetName(const char16_t* nameProposal, char16_t replaceChar) | 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. |
| static GetAltStartPath() | Gets or sets the alternate startup path, which is referred to by some external formula references. |
| static GetDateTimeFromDouble(double doubleValue, bool date1904) | Convert the double value to the date time value. |
| static GetDoubleFromDateTime(const Date& dateTime, bool date1904) | Convert the date time to double value. |
| static GetDPI() | Gets the DPI of the machine. |
| static GetLibraryPath() | Gets or sets the library path which is referred to by some external formula references. |
| static GetSignificantDigits() | Gets and sets the number of significant digits. The default value is 17. |
| static GetStartupPath() | Gets or sets the startup path, which is referred to by some external formula references. |
| static GetTextWidth(const U16String& text, const Aspose::Cells::Font& font, double scaling) | Get width of text in unit of points. |
| static GetTextWidth(const char16_t* text, const Aspose::Cells::Font& font, double scaling) | Get width of text in unit of points. |
| static GetUsedColors(const Workbook& workbook) | Gets all used colors in the workbook. |
| static GetVersion() | Get the release version. |
| static IsCloudPlatform() | Please set this property True when running on a cloud platform, such as: Azure, AWSLambda, etc,. |
| static MergeFiles(const Vector <U16String>& files, const U16String& cachedFile, const U16String& destFile) | Merges some large xls files to a xls file. |
| static MergeFiles(const Vector <U16String>& files, const char16_t* cachedFile, const char16_t* destFile) | Merges some large xls files to a xls file. |
| static NeedQuoteInFormula(const U16String& sheetName) | Indicates whether the name of the sheet should be enclosed in single quotes. |
| static NeedQuoteInFormula(const char16_t* sheetName) | Indicates whether the name of the sheet should be enclosed in single quotes. |
| static RowIndexToName(int32_t row) | Gets row name according to row index. |
| static RowNameToIndex(const U16String& rowName) | Gets row index according to row name. |
| static RowNameToIndex(const char16_t* rowName) | Gets row index according to row name. |
| static SetAltStartPath(const U16String& value) | Gets or sets the alternate startup path, which is referred to by some external formula references. |
| static SetAltStartPath(const char16_t* value) | Gets or sets the alternate startup path, which is referred to by some external formula references. |
| static SetDPI(double value) | Gets the DPI of the machine. |
| static SetIsCloudPlatform(bool value) | Please set this property True when running on a cloud platform, such as: Azure, AWSLambda, etc,. |
| static SetLibraryPath(const U16String& value) | Gets or sets the library path which is referred to by some external formula references. |
| static SetLibraryPath(const char16_t* value) | Gets or sets the library path which is referred to by some external formula references. |
| static SetSignificantDigits(int32_t value) | Gets and sets the number of significant digits. The default value is 17. |
| static SetStartupPath(const U16String& value) | Gets or sets the startup path, which is referred to by some external formula references. |
| static SetStartupPath(const char16_t* value) | Gets or sets the startup path, which is referred to by some external formula references. |
See Also
- Namespace Aspose::Cells
- Library Aspose.Cells for C++