Shape

class Shape(*args, **options)

shapes 集合中的一员:

>>> import xlwings as xw
>>> sht = xw.books['Book1'].sheets[0]
>>> sht.shapes[0]  # or sht.shapes['ShapeName']
<Shape 'Rectangle 1' in <Sheet [Book1]Sheet1>>

在 0.9.0 版本发生变更.

activate()

激活形状(shape)。

Added in version 0.5.0.

property api

返回正在使用的引擎的原生对象( pywin32appscript 对象)。

Added in version 0.19.2.

delete()

删除形状。

Added in version 0.5.0.

property height

返回或者设置形状的高度,单位是 point

Added in version 0.5.0.

property left

返回或者设置代表形状的水平位置,单位是 point

Added in version 0.5.0.

property name

返回形状的名称

Added in version 0.5.0.

property parent

返回形状所属的对象。

Added in version 0.9.0.

scale_height(factor, relative_to_original_size=False, scale='scale_from_top_left')
factorfloat

For example 1.5 to scale it up to 150%

relative_to_original_sizebool, optional

If False, it scales relative to current height (default). For True must be a picture or OLE object.

scalestr, optional

One of scale_from_top_left (default), scale_from_bottom_right, scale_from_middle

Added in version 0.19.2.

scale_width(factor, relative_to_original_size=False, scale='scale_from_top_left')
factorfloat

For example 1.5 to scale it up to 150%

relative_to_original_sizebool, optional

If False, it scales relative to current width (default). For True must be a picture or OLE object.

scalestr, optional

One of scale_from_top_left (default), scale_from_bottom_right, scale_from_middle

Added in version 0.19.2.

property text

Returns or sets the text of a shape.

Added in version 0.21.4.

property top

返回或设置形状的垂直位置,单位为 point

Added in version 0.5.0.

property type

返回形状的类型。

Added in version 0.9.0.

property width

返回或者设置形状的宽度,单位是 point

Added in version 0.5.0.