Get Connection points from shape
Aspose.Cells for Python via .NET provide rich features to manage shapes in the spreadsheet. Sometimes there is a need to get the connection points of a shape for aligning or placing the shapes at the appropriate place. For this purpose, all the connection points are required. The following code can be used to get the list of connection points of a shape by using the Shape.ConnectionPoints property.
from aspose.cells import Workbook | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# Instantiate a new Workbook. | |
workbook = Workbook() | |
# Get the first worksheet in the book. | |
worksheet = workbook.worksheets[0] | |
# Add a new textbox to the collection. | |
textboxIndex = worksheet.text_boxes.add(2, 1, 160, 200) | |
# Access your text box which is also a shape object from shapes collection | |
shape = workbook.worksheets[0].shapes[0] | |
# Get all the connection points in this shape | |
ConnectionPoints = shape.get_connection_points() | |
# Display all the shape points | |
for pt in ConnectionPoints: | |
print("X = " + str(pt[0]) + ", Y = " + str(pt[1])) |