Aspose.Cells FOSS
Python
Shape

Shape

aspose-cells-foss podržava dodavanje geometrijskih oblika i tekstualnih okvira u radne listove putem ShapeCollection (ws.shapes). Svaki oblik je predstavljen kao Shape objekat sa konfigurisanim svojstvima popunjavanja, linije i teksta.

from aspose.cells_foss import (
    MsoDrawingType, FillType, MsoLineDashStyle,
    TextAlignmentType, TextAnchorType,
    MsoFillFormat, MsoLineFormat, ShapeFont, Shape,
)

MsoDrawingType

MsoDrawingType je IntEnum koji identifikuje tip geometrijskog oblika.

NameTypeAccessDescription
upper_left_row``Read/WriteGets or sets the upper left row.
upper_left_column``Read/WriteGets or sets the upper left column.
lower_right_row``Read/WriteGets or sets the lower right row.
lower_right_column``Read/WriteGets or sets the lower right column.
upper_left_row_offset``Read/WriteGets or sets the upper left row offset.
upper_left_column_offset``Read/WriteGets or sets the upper left column offset.
lower_right_row_offset``Read/WriteGets or sets the lower right row offset.
lower_right_column_offset``Read/WriteGets or sets the lower right column offset.
name``ReadGets the name.
drawing_type``ReadGets the drawing type.
fill``ReadGets the fill.
line``ReadGets the line.
text``ReadGets the text.
font``ReadGets the font.
text_horizontal_alignment``ReadGets the text horizontal alignment.
text_vertical_alignment``ReadGets the text vertical alignment.
is_text_wrapped``ReadGets the is text wrapped.
is_locked``ReadGets the is locked.
is_hidden``ReadGets the is hidden.
placement``ReadGets the placement.
hyperlink``ReadGets the hyperlink.

FillType

FillType je IntEnum koji identifikuje tip popunjavanja primenjenog na oblik.

SignatureDescription
__init__(drawing_type, upper_left_row, upper_left_column, lower_right_row, lower_right_column)
copy()Creates a duplicate of the shape object

MsoLineDashStyle

MsoLineDashStyle je IntEnum za šablon isprekidane linije ivice/okvira.

TextAlignmentType

TextAlignmentType je IntEnum za horizontalno poravnanje teksta unutar oblika.

TextAnchorType

TextAnchorType je IntEnum za vertikalno sidrenje teksta unutar oblika.

MsoFillFormat

Upravlja izgledom popunjavanja oblika. Pristupa se putem shape.fill.

copy 

fill.copy() -> MsoFillFormat

Vraća duboku kopiju ovih postavki popunjavanja.

MsoLineFormat

Upravlja izgledom konture/ivice oblika. Pristupa se putem shape.line.

copy 

line.copy() -> MsoLineFormat

Vraća duboku kopiju ovih postavki linije.

ShapeFont

Upravlja fontom teksta unutar oblika. Dostupno putem shape.font.

copy 

font.copy() -> ShapeFont

Vraća duboku kopiju ovih postavki fonta.

Shape objekti se ne konstrušu direktno. Koristite ws.shapes.add(...) ili ws.shapes.add_text_box(...).

copy 

shape.copy() -> Shape

Vraća duboku kopiju ovog oblika sa svim očuvanim formatiranjem.

ShapeCollection

ShapeCollection se pristupa kao ws.shapes. Sadrži sve oblike na radnom listu.

add 

ws.shapes.add(
    drawing_type: MsoDrawingType,
    upper_left_row: int,
    upper_left_column: int,
    lower_right_row: int,
    lower_right_column: int
) -> Shape

Dodaje oblik navedenog tipa. Svi argumenti položaja su indeksirani od 0 za red/kolonu.

add_text_box 

ws.shapes.add_text_box(
    upper_left_row: int,
    upper_left_column: int,
    lower_right_row: int,
    lower_right_column: int
) -> Shape

Prečica za add(MsoDrawingType.TEXT_BOX, ...).

Svojstva i iteracija

Dodaj pravougaonik sa jednobojnim popunjavanjem 

from aspose.cells_foss import Workbook, MsoDrawingType, FillType, MsoLineDashStyle, TextAlignmentType

wb = Workbook()
ws = wb.worksheets[0]

# Add a blue rectangle spanning rows 1-5, columns 1-4 (0-based)
rect = ws.shapes.add(MsoDrawingType.RECTANGLE, 1, 1, 5, 4)
rect.name = "BlueBox"

rect.fill.fill_type = FillType.SOLID
rect.fill.fore_color = "4472C4"      # blue
rect.fill.transparency = 0.0

rect.line.is_visible = True
rect.line.color = "1F3864"           # dark blue
rect.line.weight = 2
rect.line.dash_style = MsoLineDashStyle.SOLID

rect.text = "Sales Summary"
rect.font.bold = True
rect.font.color = "FFFFFF"           # white text
rect.font.size = 12
rect.text_horizontal_alignment = TextAlignmentType.CENTER

wb.save("shapes.xlsx")

Dodaj tekstualni okvir 

from aspose.cells_foss import Workbook

wb = Workbook()
ws = wb.worksheets[0]

tb = ws.shapes.add_text_box(2, 0, 5, 3)
tb.name = "NoteBox"
tb.text = "Review this section before publishing."
tb.font.italic = True
tb.font.color = "595959"
tb.is_text_wrapped = True
tb.line.is_visible = True
tb.line.color = "BFBFBF"

wb.save("textbox.xlsx")

Vidi i

 Српски