Example:
# Create a new Workbook. workbook = Workbook() # Get the first worksheet. sheet = workbook.getWorksheets().get(0) # Get the worksheet cells collection. cells = sheet.getCells() # Input a value. cells.get("B3").putValue("Employee:") # Set it bold. cells.get("B3").getStyle().getFont().setBold(True) # Input some values that denote the input range # for the combo box. cells.get("A2").putValue("Emp001") cells.get("A3").putValue("Emp002") cells.get("A4").putValue("Emp003") cells.get("A5").putValue("Emp004") cells.get("A6").putValue("Emp005") cells.get("A7").putValue("Emp006") # Add a new combo box. comboBox = sheet.getShapes().addShape(MsoDrawingType.COMBO_BOX, 2, 0, 2, 0, 22, 100) # Set the linked cell comboBox.setLinkedCell("A1") # Set the input range. comboBox.setInputRange("A2:A7") # Set no. of list lines displayed in the combo # box's list portion. comboBox.setDropDownLines(5) # Set the combo box with 3-D shading. comboBox.setShadow(True) # AutoFit Columns sheet.autoFitColumns() # Saves the file. workbook.save("Book1.xls")
Property Getters/Setters Summary | ||
---|---|---|
method | getActualLowerRightRow() | |
Get the actual bottom row. | ||
method | getAlternativeText() | |
method | setAlternativeText(value) | |
Returns or sets the descriptive (alternative) text string of the |
||
method | getAutoShapeType() | |
method | setAutoShapeType(value) | |
Gets the auto shape type. The value of the property is AutoShapeType integer constant. | ||
method | getBottom() | |
method | setBottom(value) | |
Represents the width of the shape's vertical offset from its lower bottom corner row, in unit of pixels. | ||
method | getConnectionPoints() | |
Get the connection points | ||
method | getControlData() | |
Gets the data of control. | ||
method | getDropDownLines() | |
method | setDropDownLines(value) | |
Gets or sets the number of list lines displayed in the drop-down portion of a combo box. | ||
method | getFill() | |
Returns a |
||
method | getFillFormat() | |
Returns a MsoFillFormat object that contains fill formatting properties for the specified shape. | ||
method | getFont() | |
method | setFont(value) | |
Represents the font of shape. | ||
method | getFormat() | |
Represents the setting of the shape's formatting. | ||
method | getFormatPicture() | |
Gets and sets the options of the picture format. | ||
method | getGeometry() | |
Gets the geometry | ||
method | getGlow() | |
Represents a object that specifies glow effect for the chart element or shape. | ||
method | getGroup() | |
Gets the group shape which contains this shape. | ||
method | hasLine() | |
method | setHasLine(value) | |
Gets and sets the line border of the shape is visible. | ||
method | getHeight() | |
method | setHeight(value) | |
Represents the height of shape, in unit of pixel. | ||
method | getHeightCM() | |
method | setHeightCM(value) | |
Represents the height of the shape, in unit of inches. | ||
method | getHeightInch() | |
method | setHeightInch(value) | |
Represents the height of the shape, in unit of inches. | ||
method | getHeightInChart() | |
method | setHeightInChart(value) | |
Represents the vertical offset of shape from the top border of the parent shape, in unit of 1/4000 of height of the parent shape.. | ||
method | getHeightInShape() | |
method | setHeightInShape(value) | |
Represents the vertical offset of shape from the top border of the parent shape, in unit of 1/4000 of height of the parent shape.. | ||
method | getHeightPt() | |
method | setHeightPt(value) | |
Represents the height of the shape, in unit of points. | ||
method | getHeightScale() | |
method | setHeightScale(value) | |
Gets and sets the height scale,in unit of percent of the original picture height. If the shape is not picture ,the HeightScale property only returns 100; | ||
method | getHtmlText() | |
method | setHtmlText(value) | |
Gets and sets the html string which contains data and some formats in this textbox. | ||
method | getHyperlink() | |
Gets the hyperlink of the shape. | ||
method | getId() | |
Gets the identifier of this shape. | ||
method | getInputRange() | |
method | setInputRange(value) | |
Gets or sets the worksheet range used to fill the specified combo box. | ||
method | isEquation() | |
Inidicates whether the shape only contains an equation. | ||
method | isFilled() | |
method | setFilled(value) | |
Indicates whether the fill format is visible. | ||
method | isFlippedHorizontally() | |
method | setFlippedHorizontally(value) | |
Gets and sets whether shape is horizontally flipped . | ||
method | isFlippedVertically() | |
method | setFlippedVertically(value) | |
Gets and sets whether shape is vertically flipped . | ||
method | isGroup() | |
Indicates whether the shape is a group. | ||
method | isHidden() | |
method | setHidden(value) | |
Indicates whether the object is visible. | ||
method | isLockAspectRatio() | |
method | setLockAspectRatio(value) | |
True means that don't allow changes in aspect ratio. | ||
method | isLocked() | |
method | setLocked(value) | |
True if the object is locked, False if the object can be modified when the sheet is protected. | ||
method | isPrintable() | |
method | setPrintable(value) | |
True if the object is printable | ||
method | isRichText() | |
Whether or not the text is rich text. | ||
method | isSmartArt() | |
Inidicates whether the shape is smart art. | ||
method | isTextWrapped() | |
method | setTextWrapped(value) | |
Gets and sets the text wrapped type of the shape which contains text. | ||
method | isWordArt() | |
Indicates whether this shape is a word art. | ||
method | getLeft() | |
method | setLeft(value) | |
Represents the horizontal offset of shape from its left column, in unit of pixels. | ||
method | getLeftCM() | |
method | setLeftCM(value) | |
Represents the horizontal offset of shape from its left column, in unit of centimeters. | ||
method | getLeftInch() | |
method | setLeftInch(value) | |
Represents the horizontal offset of shape from its left column, in unit of inches. | ||
method | getLeftInChart() | |
method | setLeftInChart(value) | |
Represents the vertical offset of shape from the left border of the parent shape, in unit of 1/4000 of width of the parent shape. | ||
method | getLeftInShape() | |
method | setLeftInShape(value) | |
Represents the horizontal offset of shape from the left border of the parent shape, in unit of 1/4000 of width of the parent shape. | ||
method | getLeftToCorner() | |
method | setLeftToCorner(value) | |
Gets and sets the horizonal offset of shape from worksheet left border. | ||
method | getLine() | |
Gets line style | ||
method | getLineFormat() | |
Returns a MsoLineFormat object that contains line formatting properties for the specified shape. | ||
method | getLinkedCell() | |
method | setLinkedCell(value) | |
Gets or sets the worksheet range linked to the control's value. | ||
method | getLowerDeltaX() | |
method | setLowerDeltaX(value) | |
Gets or sets the shape's horizontal offset from its lower right corner column.
|
||
method | getLowerDeltaY() | |
method | setLowerDeltaY(value) | |
Gets or sets the shape's vertical offset from its lower right corner row.
|
||
method | getLowerRightColumn() | |
method | setLowerRightColumn(value) | |
Represents lower right corner column index. | ||
method | getLowerRightRow() | |
method | setLowerRightRow(value) | |
Represents lower right corner row index. | ||
method | getMacroName() | |
method | setMacroName(value) | |
Gets and sets the name of macro. | ||
method | getMsoDrawingType() | |
Gets and sets mso drawing type. The value of the property is MsoDrawingType integer constant. | ||
method | getName() | |
method | setName(value) | |
Gets and sets the name of the shape. | ||
method | getPaths() | |
Gets the paths of a custom geometric shape. | ||
method | getPlacement() | |
method | setPlacement(value) | |
Represents the way the drawing object is attached to the cells below it. The property controls the placement of an object on a worksheet. The value of the property is PlacementType integer constant. | ||
method | getPositionX() | |
method | setPositionX(value) | |
Gets and sets the horizonal offset of shape from worksheet left border,in unit of pixels. | ||
method | getPositionY() | |
method | setPositionY(value) | |
Gets and sets the vertical offset of shape from worksheet top border,in unit of pixels. | ||
method | getReflection() | |
Represents a object that specifies reflection effect for the chart element or shape. | ||
method | getRelativeToOriginalPictureSize() | |
method | setRelativeToOriginalPictureSize(value) | |
Indicates whether shape is relative to original picture size. | ||
method | getRight() | |
method | setRight(value) | |
Represents the width of the shape's horizontal offset from its lower right corner column, in unit of pixels. | ||
method | getRotationAngle() | |
method | setRotationAngle(value) | |
Gets and sets the rotation of the shape. | ||
method | getSelectedCell() | |
Gets the selected cell in the input range of the combo box. | ||
method | getSelectedIndex() | |
method | setSelectedIndex(value) | |
Gets or sets the index number of the currently selected item in a list box or combo box. Zero-based. | ||
method | getSelectedValue() | |
Gets the selected value of the combox box. | ||
method | getShadow() | |
method | setShadow(value) | |
Indicates whether the combobox has 3-D shading. | ||
method | getShadowEffect() | |
Represents a object that specifies shadow effect for the chart element or shape. | ||
method | getSoftEdges() | |
method | setSoftEdges(value) | |
Gets and sets the radius of blur to apply to the edges, in unit of points. | ||
method | getSpid() | |
Specifies an optional string that an application can use to Identify the particular shape. | ||
method | getSpt() | |
Specifies an optional number that an application can use to associate the particular shape with a defined shape type. | ||
method | getText() | |
method | setText(value) | |
Represents the string in this TextBox object. | ||
method | getTextBody() | |
Gets and ses the setting of the shape's text. | ||
method | getTextDirection() | |
method | setTextDirection(value) | |
Gets/Sets the direction of the text flow for this object. The value of the property is TextDirectionType integer constant. | ||
method | getTextEffect() | |
Returns a TextEffectFormat object that contains text-effect formatting properties for the specified shape. Applies to Shape objects that represent WordArt. | ||
method | getTextFrame() | |
Returns a TextFrame object that contains the alignment and anchoring properties for the specified shape. | ||
method | getTextHorizontalAlignment() | |
method | setTextHorizontalAlignment(value) | |
Gets and sets the text horizontal alignment type of the shape. The value of the property is TextAlignmentType integer constant. | ||
method | getTextHorizontalOverflow() | |
method | setTextHorizontalOverflow(value) | |
Gets and sets the text horizontal overflow type of the shape which contains text. The value of the property is TextOverflowType integer constant. | ||
method | getTextOptions() | |
Represents the text options of the shape. | ||
method | getTextOrientationType() | |
method | setTextOrientationType(value) | |
Gets and sets the text orientation type of the shape. The value of the property is TextOrientationType integer constant. | ||
method | getTextShapeType() | |
method | setTextShapeType(value) | |
Gets and sets the preset text shape type. The value of the property is AutoShapeType integer constant. | ||
method | getTextVerticalAlignment() | |
method | setTextVerticalAlignment(value) | |
Gets and sets the text vertical alignment type of the shape. The value of the property is TextAlignmentType integer constant. | ||
method | getTextVerticalOverflow() | |
method | setTextVerticalOverflow(value) | |
Gets and sets the text vertical overflow type of the shape which contains text. The value of the property is TextOverflowType integer constant. | ||
method | getThreeDFormat() | |
Gets and sets 3d format of the shape. | ||
method | getTitle() | |
method | setTitle(value) | |
Specifies the title (caption) of the current shape object. | ||
method | getTop() | |
method | setTop(value) | |
Represents the vertical offset of shape from its top row, in unit of pixels. | ||
method | getTopCM() | |
method | setTopCM(value) | |
Represents the vertical offset of shape from its top row, in unit of centimeters. | ||
method | getTopInch() | |
method | setTopInch(value) | |
Represents the vertical offset of shape from its top row, in unit of inches. | ||
method | getTopInChart() | |
method | setTopInChart(value) | |
Represents the vertical offset of shape from the top border of the parent shape, in unit of 1/4000 of height of the parent shape. | ||
method | getTopInShape() | |
method | setTopInShape(value) | |
Represents the vertical offset of shape from the top border of the parent shape, in unit of 1/4000 of height of the parent shape. | ||
method | getTopToCorner() | |
method | setTopToCorner(value) | |
Gets and sets the vertical offset of shape from worksheet top boder,in unit of pixel | ||
method | getType() | |
Gets the auto shape type. The value of the property is AutoShapeType integer constant. | ||
method | getUpperDeltaX() | |
method | setUpperDeltaX(value) | |
Gets or sets the shape's horizontal offset from its upper left corner column.
|
||
method | getUpperDeltaY() | |
method | setUpperDeltaY(value) | |
Gets or sets the shape's vertical offset from its upper left corner row.
|
||
method | getUpperLeftColumn() | |
method | setUpperLeftColumn(value) | |
Represents upper left corner column index. | ||
method | getUpperLeftRow() | |
method | setUpperLeftRow(value) | |
Represents upper left corner row index. | ||
method | getWidth() | |
method | setWidth(value) | |
Represents the width of shape, in unit of pixels. | ||
method | getWidthCM() | |
method | setWidthCM(value) | |
Represents the width of the shape, in unit of centimeters. | ||
method | getWidthInch() | |
method | setWidthInch(value) | |
Represents the width of the shape, in unit of inch. | ||
method | getWidthInChart() | |
method | setWidthInChart(value) | |
Represents the width of the shape, in unit of 1/4000 of the parent shape. | ||
method | getWidthInShape() | |
method | setWidthInShape(value) | |
Represents the width of the shape, in unit of 1/4000 of the parent shape. | ||
method | getWidthPt() | |
method | setWidthPt(value) | |
Represents the width of the shape, in unit of point. | ||
method | getWidthScale() | |
method | setWidthScale(value) | |
Gets and sets the width scale, in unit of percent of the original picture width. If the shape is not picture ,the WidthScale property only returns 100; | ||
method | getX() | |
method | setX(value) | |
Gets and sets the horizontal offset of shape from worksheet left border,in unit of pixels. | ||
method | getY() | |
method | setY(value) | |
Gets and sets the vertical offset of shape from worksheet top border,in unit of pixels. | ||
method | getZOrderPosition() | |
method | setZOrderPosition(value) | |
Returns the position of a shape in the z-order. |
Method Summary | ||
---|---|---|
method | addHyperlink(address) | → inherited from Shape |
Adds a hyperlink to the shape. | ||
method | alignTopRightCorner(topRow, rightColumn) | → inherited from Shape |
Moves the picture to the top-right corner. | ||
method | calculateTextSize() | → inherited from Shape |
Recalculate the text area | ||
method | characters(startIndex, length) | → inherited from Shape |
Returns a Characters object that represents a range of characters within the text. | ||
method | formatCharacters(startIndex, length, font) | → inherited from Shape |
Format some chararcters with the font setting. | ||
method | formatCharacters(startIndex, length, font, flag) | → inherited from Shape |
Format some chararcters with the font setting. | ||
method | getCharacters() | → inherited from Shape |
Returns all Characters objects that represents a range of characters within the text . | ||
method | getInputRange(isR1C1, isLocal) | → inherited from Shape |
Gets the range used to fill the control. | ||
method | getLinkedCell(isR1C1, isLocal) | → inherited from Shape |
Gets the range linked to the control's value. | ||
method | getLockedProperty(type) | → inherited from Shape |
Gets the value of locked property. | ||
method | getResultOfSmartArt() | → inherited from Shape |
Converting smart art to grouped shapes. | ||
method | moveToRange(upperLeftRow, upperLeftColumn, lowerRightRow, lowerRightColumn) | → inherited from Shape |
Moves the shape to a specified range. | ||
method | removeHyperlink() | → inherited from Shape |
Remove the hyperlink of the shape. | ||
method | setInputRange(formula, isR1C1, isLocal) | → inherited from Shape |
Sets the range used to fill the control. | ||
method | setLinkedCell(formula, isR1C1, isLocal) | → inherited from Shape |
Sets the range linked to the control's value. | ||
method | setLockedProperty(type, value) | → inherited from Shape |
Set the locked property. | ||
method | toFrontOrBack(orders) | → inherited from Shape |
Brings the shape to the front or sends the shape to back. | ||
method | toImage(imageFile, options) | → inherited from Shape |
Saves the shape to a file. | ||
method | updateSelectedValue() | → inherited from Shape |
Update the selected value by the value of the linked cell. |
Property Getters/Setters Detail |
---|
getSelectedIndex/setSelectedIndex : int | |
int getSelectedIndex() / setSelectedIndex(value) |
getSelectedValue : String | |
String getSelectedValue() |
getSelectedCell : Cell | |
Cell getSelectedCell() |
getShadow/setShadow : boolean | |
boolean getShadow() / setShadow(value) |
getDropDownLines/setDropDownLines : int | |
int getDropDownLines() / setDropDownLines(value) |
getMacroName/setMacroName : String | |
String getMacroName() / setMacroName(value) |
isEquation : boolean | |
boolean isEquation() |
isSmartArt : boolean | |
boolean isSmartArt() |
getZOrderPosition/setZOrderPosition : int | |
int getZOrderPosition() / setZOrderPosition(value) |
getName/setName : String | |
String getName() / setName(value) |
getAlternativeText/setAlternativeText : String | |
String getAlternativeText() / setAlternativeText(value) |
getTitle/setTitle : String | |
String getTitle() / setTitle(value) |
getLineFormat : MsoLineFormat | |
MsoLineFormat getLineFormat() |
getFillFormat : MsoFillFormat | |
MsoFillFormat getFillFormat() |
getFormat : ShapeFormat | |
ShapeFormat getFormat() |
getLine : LineFormat | |
LineFormat getLine() |
getFill : FillFormat | |
FillFormat getFill() |
getShadowEffect : ShadowEffect | |
ShadowEffect getShadowEffect() |
getReflection : ReflectionEffect | |
ReflectionEffect getReflection() |
getGlow : GlowEffect | |
GlowEffect getGlow() |
getSoftEdges/setSoftEdges : float | |
float getSoftEdges() / setSoftEdges(value) |
getThreeDFormat : ThreeDFormat | |
ThreeDFormat getThreeDFormat() |
getTextFrame : MsoTextFrame | |
MsoTextFrame getTextFrame() |
getFormatPicture : MsoFormatPicture | |
MsoFormatPicture getFormatPicture() |
isHidden/setHidden : boolean | |
boolean isHidden() / setHidden(value) |
isLockAspectRatio/setLockAspectRatio : boolean | |
boolean isLockAspectRatio() / setLockAspectRatio(value) |
getRotationAngle/setRotationAngle : float | |
float getRotationAngle() / setRotationAngle(value) |
getHyperlink : Hyperlink | |
Hyperlink getHyperlink() |
getId : int | |
int getId() |
getSpid : String | |
String getSpid() |
getSpt : int | |
int getSpt() |
isGroup : boolean | |
boolean isGroup() |
isWordArt : boolean | |
boolean isWordArt() |
getTextEffect : TextEffectFormat | |
TextEffectFormat getTextEffect() |
isLocked/setLocked : boolean | |
boolean isLocked() / setLocked(value) |
isPrintable/setPrintable : boolean | |
boolean isPrintable() / setPrintable(value) |
getMsoDrawingType : int | |
int getMsoDrawingType() |
getAutoShapeType/setAutoShapeType : int | |
int getAutoShapeType() / setAutoShapeType(value) |
getPlacement/setPlacement : int | |
int getPlacement() / setPlacement(value) |
getUpperLeftRow/setUpperLeftRow : int | |
int getUpperLeftRow() / setUpperLeftRow(value) |
getUpperDeltaY/setUpperDeltaY : int | |
int getUpperDeltaY() / setUpperDeltaY(value) |
getUpperLeftColumn/setUpperLeftColumn : int | |
int getUpperLeftColumn() / setUpperLeftColumn(value) |
getUpperDeltaX/setUpperDeltaX : int | |
int getUpperDeltaX() / setUpperDeltaX(value) |
getLowerRightRow/setLowerRightRow : int | |
int getLowerRightRow() / setLowerRightRow(value) |
getLowerDeltaY/setLowerDeltaY : int | |
int getLowerDeltaY() / setLowerDeltaY(value) |
getLowerRightColumn/setLowerRightColumn : int | |
int getLowerRightColumn() / setLowerRightColumn(value) |
getLowerDeltaX/setLowerDeltaX : int | |
int getLowerDeltaX() / setLowerDeltaX(value) |
getRight/setRight : int | |
int getRight() / setRight(value) |
getBottom/setBottom : int | |
int getBottom() / setBottom(value) |
getWidth/setWidth : int | |
int getWidth() / setWidth(value) |
getWidthInch/setWidthInch : float | |
float getWidthInch() / setWidthInch(value) |
getWidthPt/setWidthPt : float | |
float getWidthPt() / setWidthPt(value) |
getWidthCM/setWidthCM : float | |
float getWidthCM() / setWidthCM(value) |
getHeight/setHeight : int | |
int getHeight() / setHeight(value) |
getHeightInch/setHeightInch : float | |
float getHeightInch() / setHeightInch(value) |
getHeightPt/setHeightPt : float | |
float getHeightPt() / setHeightPt(value) |
getHeightCM/setHeightCM : float | |
float getHeightCM() / setHeightCM(value) |
getLeft/setLeft : int | |
int getLeft() / setLeft(value) |
getLeftInch/setLeftInch : float | |
float getLeftInch() / setLeftInch(value) |
getLeftCM/setLeftCM : float | |
float getLeftCM() / setLeftCM(value) |
getTop/setTop : int | |
int getTop() / setTop(value) |
getTopInch/setTopInch : float | |
float getTopInch() / setTopInch(value) |
getTopCM/setTopCM : float | |
float getTopCM() / setTopCM(value) |
getTopToCorner/setTopToCorner : int | |
int getTopToCorner() / setTopToCorner(value) |
getLeftToCorner/setLeftToCorner : int | |
int getLeftToCorner() / setLeftToCorner(value) |
getX/setX : int | |
int getX() / setX(value) |
getY/setY : int | |
int getY() / setY(value) |
getWidthScale/setWidthScale : int | |
int getWidthScale() / setWidthScale(value) |
getHeightScale/setHeightScale : int | |
int getHeightScale() / setHeightScale(value) |
getTopInShape/setTopInShape : int | |
int getTopInShape() / setTopInShape(value) |
getLeftInShape/setLeftInShape : int | |
int getLeftInShape() / setLeftInShape(value) |
getWidthInShape/setWidthInShape : int | |
int getWidthInShape() / setWidthInShape(value) |
getHeightInShape/setHeightInShape : int | |
int getHeightInShape() / setHeightInShape(value) |
getHeightInChart/setHeightInChart : int | |
int getHeightInChart() / setHeightInChart(value) |
getLeftInChart/setLeftInChart : int | |
int getLeftInChart() / setLeftInChart(value) |
getTopInChart/setTopInChart : int | |
int getTopInChart() / setTopInChart(value) |
getWidthInChart/setWidthInChart : int | |
int getWidthInChart() / setWidthInChart(value) |
getPositionX/setPositionX : int | |
int getPositionX() / setPositionX(value) |
getPositionY/setPositionY : int | |
int getPositionY() / setPositionY(value) |
getGroup : GroupShape | |
GroupShape getGroup() |
getType : int | |
int getType() |
hasLine/setHasLine : boolean | |
boolean hasLine() / setHasLine(value) |
isFilled/setFilled : boolean | |
boolean isFilled() / setFilled(value) |
isFlippedHorizontally/setFlippedHorizontally : boolean | |
boolean isFlippedHorizontally() / setFlippedHorizontally(value) |
isFlippedVertically/setFlippedVertically : boolean | |
boolean isFlippedVertically() / setFlippedVertically(value) |
getActualLowerRightRow : int | |
int getActualLowerRightRow() |
getConnectionPoints : Float[] | |
Float[] getConnectionPoints() |
getRelativeToOriginalPictureSize/setRelativeToOriginalPictureSize : boolean | |
boolean getRelativeToOriginalPictureSize() / setRelativeToOriginalPictureSize(value) |
getLinkedCell/setLinkedCell : String | |
String getLinkedCell() / setLinkedCell(value) |
getInputRange/setInputRange : String | |
String getInputRange() / setInputRange(value) |
getTextShapeType/setTextShapeType : int | |
int getTextShapeType() / setTextShapeType(value) |
getTextBody : FontSettingCollection | |
FontSettingCollection getTextBody() |
getFont/setFont : Font | |
Font getFont() / setFont(value) |
getTextOptions : TextOptions | |
TextOptions getTextOptions() |
getText/setText : String | |
String getText() / setText(value) |
isRichText : boolean | |
boolean isRichText() |
getHtmlText/setHtmlText : String | |
String getHtmlText() / setHtmlText(value) |
getTextVerticalOverflow/setTextVerticalOverflow : int | |
int getTextVerticalOverflow() / setTextVerticalOverflow(value) |
getTextHorizontalOverflow/setTextHorizontalOverflow : int | |
int getTextHorizontalOverflow() / setTextHorizontalOverflow(value) |
isTextWrapped/setTextWrapped : boolean | |
boolean isTextWrapped() / setTextWrapped(value) |
getTextOrientationType/setTextOrientationType : int | |
int getTextOrientationType() / setTextOrientationType(value) |
getTextHorizontalAlignment/setTextHorizontalAlignment : int | |
int getTextHorizontalAlignment() / setTextHorizontalAlignment(value) |
getTextVerticalAlignment/setTextVerticalAlignment : int | |
int getTextVerticalAlignment() / setTextVerticalAlignment(value) |
getTextDirection/setTextDirection : int | |
int getTextDirection() / setTextDirection(value) |
getControlData : byte[] | |
byte[] getControlData() |
getPaths : ShapePathCollection | |
ShapePathCollection getPaths() |
getGeometry : Geometry | |
Geometry getGeometry() |
Method Detail |
---|
setLinkedCell | |
setLinkedCell(formula, isR1C1, isLocal) |
formula: String
- The range linked to the control's value.isR1C1: boolean
- Whether the formula needs to be formatted as R1C1.isLocal: boolean
- Whether the formula needs to be formatted by locale.getInputRange | |
String getInputRange(isR1C1, isLocal) |
isR1C1: boolean
- Whether the formula needs to be formatted as R1C1.isLocal: boolean
- Whether the formula needs to be formatted by locale.setInputRange | |
setInputRange(formula, isR1C1, isLocal) |
formula: String
- The range used to fill the control.isR1C1: boolean
- Whether the formula needs to be formatted as R1C1.isLocal: boolean
- Whether the formula needs to be formatted by locale.updateSelectedValue | |
updateSelectedValue() |
calculateTextSize | |
int[] calculateTextSize() |
formatCharacters | |
formatCharacters(startIndex, length, font, flag) |
startIndex: int
- The start index.length: int
- The the length.font: Font
- The font setting.flag: StyleFlag
- The flag of the font setting.formatCharacters | |
formatCharacters(startIndex, length, font) |
startIndex: int
- The start index.length: int
- The the length.font: Font
- The font setting.characters | |
FontSetting characters(startIndex, length) |
startIndex: int
- The index of the start of the character.length: int
- The number of characters.getCharacters | |
ArrayList getCharacters() |
toImage | |
toImage(imageFile, options) |
getLinkedCell | |
String getLinkedCell(isR1C1, isLocal) |
isR1C1: boolean
- Whether the formula needs to be formatted as R1C1.isLocal: boolean
- Whether the formula needs to be formatted by locale.getResultOfSmartArt | |
GroupShape getResultOfSmartArt() |
toFrontOrBack | |
toFrontOrBack(orders) |
orders: int
-
If it's less than zero, sens the shape to back.
If it's greater than zero, brings the shape to front.
getLockedProperty | |
boolean getLockedProperty(type) |
type: int
- A setLockedProperty | |
setLockedProperty(type, value) |
type: int
- A value: boolean
- The value of the property.addHyperlink | |
Hyperlink addHyperlink(address) |
address: String
- Address of the hyperlink.removeHyperlink | |
removeHyperlink() |
moveToRange | |
moveToRange(upperLeftRow, upperLeftColumn, lowerRightRow, lowerRightColumn) |
upperLeftRow: int
- Upper left row index.upperLeftColumn: int
- Upper left column index.lowerRightRow: int
- Lower right row indexlowerRightColumn: int
- Lower right column indexalignTopRightCorner | |
alignTopRightCorner(topRow, rightColumn) |
topRow: int
- the row index.rightColumn: int
- the column index.