Returns the format of the specified range of cells
Rows are indexed from top to bottom beginning with 0; sheets and columns are indexed from left to right beginning with 0.
Returns the format of the specified range of cells in the specified range of sheets
Rows are indexed from top to bottom beginning with 0; sheets and columns are indexed from left to right beginning with 0.
Returns the format of the selected range of cells into the specified CellFormat object
You can use this method to loop through cells, retrieving cell formats through the same instance of the CellFormat object.
Returns the format of the specified range of cells into the specified CellFormat object
You can use this method to loop through cells, retrieving cell formats through the same instance of the CellFormat object.
Returns the format of the specified range of cells in the specified range of sheets into the specified CellFormat object
You can use this method to loop through cells, retrieving cell formats through the same instance of the CellFormat object.
Returns the width of the specified column in twips
Column width can be specified in units equal to 1/256th of the character O's width in the default font, or to twips, depending on the column width units specified for the workbook.
Returns the contents of the active cell in the first selected worksheet in edit mode format
For example, if the cell contains a formula, the text of the formula is displayed.
Returns the text value of the specified cell in the first selected worksheet in edit mode format
For example, if the cell contains a formula, the text of the formula is displayed.
Returns the text value of the specified cell in the first selected worksheet in edit mode format
For example, if the cell contains a formula, the text of the formula is displayed.
Returns the first object in the active worksheet
This method can be used in conjunction with the getNextObject method to to loop through all the objects in a worksheet.
Returns the value of the specified cell as it appears in the specified worksheet
This method returns the text as it is seen in the worksheet, including all formatting.
Returns the maximum number of calculation iterations
Iteration can be used to resolve circular references. jxcell calculates until it has iterated the number of times specified by the maximum number of iterations, or until all cells change by less than the amount specified as the maximum iteration change value.
Returns the maximum iteration change value
Iteration can be used to resolve circular references. jxcell calculates until it has iterated the number of times specified by the maximum number of iterations, or until all cells change by less than the amount specified as the maximum iteration change value.
Returns the number of the last occupied column in the specified row
This method returns the last column that is not empty, including cells that contain only formatting.
Returns the mode for interactive polygon editing
In normal polygon editing mode (0), only the width and height of polygons can be interactively edited.
Returns the current print area inuser language
The returned string is based on the user-defined name, Print_Area, which defines the worksheet range to be printed.
left position
The whole part of the value is the column containing the left side, and the fractional part of the value is the position of the left side within that column.
right position
The whole part of the value is the column containing the right side, and the fractional part of the value is the position of the right side within that column.
top position
The whole part of the value is the row containing the top side, and the fractional part of the value is the position of the top side within that row.
bottom position
The whole part of the value is the row containing the bottom side, and the fractional part of the value is the position of the bottom side within that row.