méthode copy_comments_in_range

copy_comments_in_range(self, shapes, ca, dest_row, dest_column)

Copiez tous les commentaires de la plage.


def copy_comments_in_range(self, shapes, ca, dest_row, dest_column):
    ...
ParamètreTaperDescription
shapesShapeCollectionLes formes de la source.
caCellAreaLa gamme source.
dest_rowintLa ligne de départ de la plage de destination.
dest_columnintLa colonne de début de la plage de destination.

Exemple

from aspose.cells import CellArea

comments = workbook.worksheets[0].comments
# Add comment to cell A1
commentIndex = comments.add(0, 0)
comment = comments[commentIndex]
comment.note = "First note."
comment.font.name = "Times New Roman"
# Add comment to cell B2
comments.add("B2")
comment = comments.get("B2")
comment.note = "Second note."
area1 = CellArea()
area1.start_column = 1
area1.start_row = 1
area1.end_column = 5
area1.end_row = 4
# copy
shapes.copy_comments_in_range(shapes, area1, 5, 1)

Voir également