Reference>TXLSShapes>Items :: Delphi + Excel

Returns a single shape from a TXLSShapes collection.

Syntax

property Items[Index: integer]: TXLSShape; default;

Index

Required integer. The index number of the TXLSShape object.

The following example deletes first shape from shape collection on sheet one

with Workbook.Sheets[1] do begin
  if Shapes.Count > 0 then Shapes.Items[1].Delete;
end;

This example is the same to previous.

with Workbook.Sheets[1] do begin
  if Shapes.Count > 0 then Shapes[1].Delete;
end;