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 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 one of the following number format types:
eNumberFormatTypeGeneral eNumberFormatTypeNumber eNumberFormatTypeCurrency
eNumberFormatTypeDate eNumberFormatTypeDateTime eNumberFormatTypePercent
eNumberFormatTypeFraction eNumberFormatTypeScientific eNumberFormatTypeString