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.
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.
Gets or sets the factory for creating instances with special implementation.
isCloudPlatform/setCloudPlatform
public static boolean isCloudPlatform() / public static void setCloudPlatform(boolean value)
Please set this property True when running on a cloud platform, such as: Azure, AWSLambda, etc,
Method Detail
getTextWidth
public static double getTextWidth(java.lang.String text, Font font, double scaling)
throws java.lang.Exception
Get width of text in unit of points.
Parameters:
text - The text.
font - The font of the text.
scaling - The scaling of text.
Returns:
getVersion
public static java.lang.String getVersion()
Get the release version.
Returns:
The release version.
cellNameToIndex
public static int[] cellNameToIndex(java.lang.String cellName)
Gets the cell row and column indexes according to its name.
Parameters:
cellName - Name of cell
Returns:
[0] is the row index and [1] is the column index.
cellIndexToName
public static java.lang.String cellIndexToName(int row, int column)
Gets cell name according to its row and column indexes.
Parameters:
row - Row index.
column - Column index.
Returns:
Name of cell.
columnIndexToName
public static java.lang.String columnIndexToName(int column)
Gets column name according to column index.
Parameters:
column - Column index.
Returns:
Name of column.
columnNameToIndex
public static int columnNameToIndex(java.lang.String columnName)
Gets column index according to column name.
Parameters:
columnName - Column name.
Returns:
Column index.
rowIndexToName
public static java.lang.String rowIndexToName(int row)
Gets row name according to row index.
Parameters:
row - Row index.
Returns:
Name of row.
rowNameToIndex
public static int rowNameToIndex(java.lang.String rowName)
Gets row index according to row name.
Parameters:
rowName - Row name.
Returns:
Row index.
convertR1C1FormulaToA1
public static java.lang.String convertR1C1FormulaToA1(java.lang.String r1c1Formula, int row, int column)
Converts the r1c1 formula of the cell to A1 formula.
Parameters:
r1c1Formula - The r1c1 formula.
row - The row index of the cell.
column - The column index of the cell.
Returns:
The A1 formula.
convertA1FormulaToR1C1
public static java.lang.String convertA1FormulaToR1C1(java.lang.String formula, int row, int column)
Converts A1 formula of the cell to the r1c1 formula.
Parameters:
formula - The A1 formula.
row - The row index of the cell.
column - The column index of the cell.
Returns:
The R1C1 formula.
getDateTimeFromDouble
public static com.aspose.cells.DateTime getDateTimeFromDouble(double doubleValue, boolean date1904)
Convert the double value to the date time value.
Parameters:
doubleValue - The double value.
date1904 - Date 1904 system.
Returns:
getDoubleFromDateTime
public static double getDoubleFromDateTime(com.aspose.cells.DateTime dateTime, boolean date1904)
Convert the date time to double value.
Parameters:
dateTime - The date time.
date1904 - Date 1904 system.
Returns:
getUsedColors
public static com.aspose.cells.Color[] getUsedColors(Workbook workbook)
Gets all used colors in the workbook.
Parameters:
workbook - The workbook object.
Returns:
The used colors.
addAddInFunction
public static void addAddInFunction(java.lang.String function, int minCountOfParameters, int maxCountOfParameters, int[] paramersType, int functionValueType)
Add addin function.
NOTE: This member is now obsolete. Instead,
please use WorksheetCollection.RegisterAddInFunction() methods.
This method will be removed 12 months later since January 2022.
Aspose apologizes for any inconvenience you may have experienced.
Parameters:
function - The function name.
minCountOfParameters - Minimum number of parameters this function requires
maxCountOfParameters - Maximum number of parameters this function allows.
paramersType - The excepted parameters type of the function
functionValueType - A ParameterType value. The function value type.
Merges some large xls files to a xls file.
This method only supports merging data, style and formulas to the new file.
The cached file is used to store some temporary data.
Parameters:
files - The files.
cachedFile - The cached file.
destFile - The dest file.
createSafeSheetName
public static java.lang.String createSafeSheetName(java.lang.String 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.
Parameters:
nameProposal - sheet name to be used
Returns:
createSafeSheetName
public static java.lang.String createSafeSheetName(java.lang.String nameProposal, char 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.
Parameters:
nameProposal - sheet name to be used
replaceChar - character which will be used to replace invalid characters in given sheet name
com.aspose.cells.CellsHelper