java.lang.Objectcom.aspose.cells.CellsHelper
public class CellsHelper
Constructor Summary |
---|
CellsHelper()
|
Property Getters/Setters Summary | ||
---|---|---|
static java.lang.String | getAltStartPath() | |
static void | setAltStartPath(java.lang.String value) | |
Gets or sets the alternate startup path, which is referred to by some external formula references. | ||
static java.lang.String | getFontDir() | |
static void | setFontDir(java.lang.String value) | |
When generating PDF/XPS, specific font file directory can be set in the property. If it is not set , using %WINDOWS%\fonts by default. | ||
static java.util.ArrayList | getFontDirs() | |
static void | setFontDirs(java.util.ArrayList value) | |
When generating PDF/XPS, specific font file directorys can be set in the property. If it is not set , using %WINDOWS%\fonts by default. | ||
static java.util.ArrayList | getFontFiles() | |
static void | setFontFiles(java.util.ArrayList value) | |
When generating PDF/XPS, specific font files can be set in the property. such as "d:\myfonts\myArial.ttf" | ||
static java.lang.String | getLibraryPath() | |
static void | setLibraryPath(java.lang.String value) | |
Gets or sets the library path which is referred to by some external formula references. | ||
static java.lang.String | getStartupPath() | |
static void | setStartupPath(java.lang.String value) | |
Gets or sets the startup path, which is referred to by some external formula references. |
Method Summary | ||
---|---|---|
static void | addAddInFunction(java.lang.String function, int minCountOfParameters, int maxCountOfParameters, int[] paramersType, int fuctionValueType) | |
Add addin fuction. | ||
static java.lang.String | cellIndexToName(int row, int column) | |
Gets cell name according to its row and column indexes. | ||
static int[] | cellNameToIndex(java.lang.String cellName) | |
static java.lang.String | columnIndexToName(int column) | |
Gets column name according to column index. | ||
static int | columnNameToIndex(java.lang.String columnName) | |
Gets column index according to column name. | ||
static java.lang.String | convertA1FormulaToR1C1(java.lang.String formula, int row, int column) | |
Converts A1 formula of the cell to the r1c1 formula. | ||
static java.lang.String | convertR1C1FormulaToA1(java.lang.String r1c1Formula, int row, int column) | |
Converts the r1c1 formula of the cell to A1 formula. | ||
static int | detectFileFormat(java.io.InputStream stream) | |
Detects the format type of the file stored in the stream. | ||
static int | detectFileFormat(java.lang.String fileName) | |
Detects the file format type. | ||
static int | detectLoadFormat(java.io.InputStream stream) | |
Detects the file load format. | ||
static int | detectLoadFormat(java.lang.String fileName) | |
Detects the file load format. | ||
static com.aspose.cells.DateTime | getDateTimeFromDouble(double doubleValue, boolean date1904) | |
Convert the double value to the date time value. | ||
static double | getDoubleFromDateTime(com.aspose.cells.DateTime dateTime, boolean date1904) | |
Convert the date time to double value. | ||
static com.aspose.cells.Color[] | getUsedColors(Workbook workbook) | |
Gets all used colors in the workbook. | ||
static java.lang.String | getVersion() | |
Get the release version. | ||
static boolean | isProtectedByRMS(java.io.InputStream stream) | |
Gets whether the file is protected by Microsoft Rights Management Server. | ||
static boolean | isProtectedByRMS(java.lang.String fileName) | |
Gets whtether the file is protected by Microsoft Rights Management Server. | ||
static void | mergeFiles(java.lang.String[] files, java.lang.String cachedFile, java.lang.String destFile) | |
Merges some large files to a file. | ||
static java.lang.String | rowIndexToName(int row) | |
Gets row name according to row index. | ||
static int | rowNameToIndex(java.lang.String rowName) | |
Gets row index according to row name. |
Constructor Detail |
---|
public CellsHelper()
Property Getters/Setters Detail |
---|
getFontDir/setFontDir | |
public static java.lang.String getFontDir() / public static void setFontDir(java.lang.String value) |
getFontDirs/setFontDirs | |
public static java.util.ArrayList getFontDirs() / public static void setFontDirs(java.util.ArrayList value) |
getFontFiles/setFontFiles | |
public static java.util.ArrayList getFontFiles() / public static void setFontFiles(java.util.ArrayList value) |
getStartupPath/setStartupPath | |
public static java.lang.String getStartupPath() / public static void setStartupPath(java.lang.String value) |
getAltStartPath/setAltStartPath | |
public static java.lang.String getAltStartPath() / public static void setAltStartPath(java.lang.String value) |
getLibraryPath/setLibraryPath | |
public static java.lang.String getLibraryPath() / public static void setLibraryPath(java.lang.String value) |
Method Detail |
---|
getVersion | |
public static java.lang.String getVersion() |
isProtectedByRMS | |
public static boolean isProtectedByRMS(java.lang.String fileName) throws java.lang.Exception |
fileName
- The file name.isProtectedByRMS | |
public static boolean isProtectedByRMS(java.io.InputStream stream) throws java.lang.Exception |
stream
- The file stream.cellNameToIndex | |
public static int[] cellNameToIndex(java.lang.String cellName) |
cellIndexToName | |
public static java.lang.String cellIndexToName(int row, int column) |
row
- Row index.column
- Column index.columnIndexToName | |
public static java.lang.String columnIndexToName(int column) |
column
- Column index.columnNameToIndex | |
public static int columnNameToIndex(java.lang.String columnName) |
columnName
- Column name.rowIndexToName | |
public static java.lang.String rowIndexToName(int row) |
row
- Row index.rowNameToIndex | |
public static int rowNameToIndex(java.lang.String rowName) |
rowName
- Row name.convertR1C1FormulaToA1 | |
public static java.lang.String convertR1C1FormulaToA1(java.lang.String r1c1Formula, int row, int column) |
r1c1Formula
- The r1c1 formula.row
- The row index of the cell.column
- The column index of the cell.convertA1FormulaToR1C1 | |
public static java.lang.String convertA1FormulaToR1C1(java.lang.String formula, int row, int column) |
formula
- The A1 formula.row
- The row index of the cell.column
- The column index of the cell.getDateTimeFromDouble | |
public static com.aspose.cells.DateTime getDateTimeFromDouble(double doubleValue, boolean date1904) |
doubleValue
- The double value.date1904
- Date 1904 system.getDoubleFromDateTime | |
public static double getDoubleFromDateTime(com.aspose.cells.DateTime dateTime, boolean date1904) |
dateTime
- The date time.date1904
- Date 1904 system.detectLoadFormat | |
public static int detectLoadFormat(java.lang.String fileName) throws java.lang.Exception |
fileName
- The file name.detectLoadFormat | |
public static int detectLoadFormat(java.io.InputStream stream) throws java.lang.Exception |
stream
- The stream.detectFileFormat | |
public static int detectFileFormat(java.lang.String fileName) throws java.lang.Exception |
fileName
- the file namedetectFileFormat | |
public static int detectFileFormat(java.io.InputStream stream) throws java.lang.Exception |
stream
- The streamgetUsedColors | |
public static com.aspose.cells.Color[] getUsedColors(Workbook workbook) |
workbook
- The workbook object.addAddInFunction | |
public static void addAddInFunction(java.lang.String function, int minCountOfParameters, int maxCountOfParameters, int[] paramersType, int fuctionValueType) |
function
- The function name.minCountOfParameters
- Minimum number of parameters this function requiresmaxCountOfParameters
- Maximum number of parameters this function allows.paramersType
- The excepted parameters type of the functionfuctionValueType
- A mergeFiles | |
public static void mergeFiles(java.lang.String[] files, java.lang.String cachedFile, java.lang.String destFile) throws java.lang.Exception |
files
- The files.cachedFile
- The cached file.destFile
- The dest file.