Property Getters/Setters Summary | ||
---|---|---|
static method | getAltStartPath() | |
staticmethod | setAltStartPath(value) | |
Gets or sets the alternate startup path, which is referred to by some external formula references. | ||
static method | getCustomImplementationFactory() | |
staticmethod | ||
Gets or sets the factory for creating instances with special implementation. | ||
static method | getDPI() | |
staticmethod | setDPI(value) | |
Gets the DPI of the machine. | ||
static method | getFontDir() | |
staticmethod | setFontDir(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 method | getFontDirs() | |
staticmethod | setFontDirs(value) | |
When generating PDF/XPS, specific font file directories can be set in the property. If it is not set , using %WINDOWS%\fonts by default. | ||
static method | getFontFiles() | |
staticmethod | setFontFiles(value) | |
When generating PDF/XPS, specific font files can be set in the property. Such as "d:\myfonts\myArial.ttf" | ||
static method | getLibraryPath() | |
staticmethod | setLibraryPath(value) | |
Gets or sets the library path which is referred to by some external formula references. | ||
static method | getSignificantDigits() | |
staticmethod | setSignificantDigits(value) | |
Gets and sets the number of significant digits. The default value is 17. | ||
static method | getStartupPath() | |
staticmethod | setStartupPath(value) | |
Gets or sets the startup path, which is referred to by some external formula references. |
Method Summary | ||
---|---|---|
static method | addAddInFunction(function, minCountOfParameters, maxCountOfParameters, paramersType, functionValueType) | |
Add addin function.
|
||
static method | cellIndexToName(row, column) | |
Gets cell name according to its row and column indexes.
|
||
static method | cellNameToIndex(cellName) | |
static method | columnIndexToName(column) | |
Gets column name according to column index.
|
||
static method | columnNameToIndex(columnName) | |
Gets column index according to column name.
|
||
static method | convertA1FormulaToR1C1(formula, row, column) | |
Converts A1 formula of the cell to the r1c1 formula.
|
||
static method | convertR1C1FormulaToA1(r1c1Formula, row, column) | |
Converts the r1c1 formula of the cell to A1 formula.
|
||
static method | createSafeSheetName(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 method | createSafeSheetName(nameProposal, 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 method | detectFileFormat(stream) | |
Detects the format type of the file stored in the stream.
|
||
static method | detectFileFormat(fileName) | |
Detects the file format type.
|
||
static method | detectLoadFormat(stream) | |
Detects the file load format.
|
||
static method | detectLoadFormat(fileName) | |
Detects the file load format.
|
||
static method | getDateTimeFromDouble(doubleValue, date1904) | |
Convert the double value to the date time value.
|
||
static method | getDoubleFromDateTime(dateTime, date1904) | |
Convert the date time to double value.
|
||
static method | getTextWidth(text, font, scaling) | |
Get width of text in unit of points.
|
||
static method | getUsedColors(workbook) | |
Gets all used colors in the workbook.
|
||
static method | getVersion() | |
Get the release version.
|
||
static method | isProtectedByRMS(stream) | |
Gets whether the file is protected by Microsoft Rights Management Server.
|
||
static method | isProtectedByRMS(fileName) | |
Gets whether the file is protected by Microsoft Rights Management Server.
|
||
static method | mergeFiles(files, cachedFile, destFile) | |
Merges some large xls files to a xls file.
|
||
static method | rowIndexToName(row) | |
Gets row name according to row index.
|
||
static method | rowNameToIndex(rowName) | |
Gets row index according to row name.
|
static int getSignificantDigits() / static setSignificantDigits(value)
static float getDPI() / static setDPI(value)
static String getFontDir() / static setFontDir(value)
static ArrayList getFontDirs() / static setFontDirs(value)
static ArrayList getFontFiles() / static setFontFiles(value)
static String getStartupPath() / static setStartupPath(value)
static String getAltStartPath() / static setAltStartPath(value)
static String getLibraryPath() / static setLibraryPath(value)
static CustomImplementationFactory getCustomImplementationFactory() / static setCustomImplementationFactory(value)
static float getTextWidth(text, font, scaling)
text: String
- The text.font: Font
- The font of the text.scaling: float
- The scaling of text.static String getVersion()
static boolean isProtectedByRMS(fileName)
fileName: String
- The file name.static boolean isProtectedByRMS(stream)
stream: InputStream
- The file stream.static int[] cellNameToIndex(cellName)
static String cellIndexToName(row, column)
row: int
- Row index.column: int
- Column index.static String columnIndexToName(column)
column: int
- Column index.static int columnNameToIndex(columnName)
columnName: String
- Column name.static String rowIndexToName(row)
row: int
- Row index.static int rowNameToIndex(rowName)
rowName: String
- Row name.static String convertR1C1FormulaToA1(r1c1Formula, row, column)
r1c1Formula: String
- The r1c1 formula.row: int
- The row index of the cell.column: int
- The column index of the cell.static String convertA1FormulaToR1C1(formula, row, column)
formula: String
- The A1 formula.row: int
- The row index of the cell.column: int
- The column index of the cell.static DateTime getDateTimeFromDouble(doubleValue, date1904)
doubleValue: float
- The double value.date1904: boolean
- Date 1904 system.static float getDoubleFromDateTime(dateTime, date1904)
dateTime: DateTime
- The date time.date1904: boolean
- Date 1904 system.static int detectLoadFormat(fileName)
fileName: String
- The file name.static int detectLoadFormat(stream)
stream: InputStream
- The stream.static int detectFileFormat(fileName)
fileName: String
- the file namestatic int detectFileFormat(stream)
stream: InputStream
- The streamstatic Color[] getUsedColors(workbook)
workbook: Workbook
- The workbook object.static addAddInFunction(function, minCountOfParameters, maxCountOfParameters, paramersType, functionValueType)
function: String
- The function name.minCountOfParameters: int
- Minimum number of parameters this function requiresmaxCountOfParameters: int
- Maximum number of parameters this function allows.paramersType: Number Array
- The excepted parameters type of the functionfunctionValueType: int
- A static mergeFiles(files, cachedFile, destFile)
files: String[]
- The files.cachedFile: String
- The cached file.destFile: String
- The dest file.static String createSafeSheetName(nameProposal)
nameProposal: String
- sheet name to be usedstatic String createSafeSheetName(nameProposal, replaceChar)
nameProposal: String
- sheet name to be usedreplaceChar: char
- character which will be used to replace invalid characters in given sheet name