HotXLS Docs

Shapes property

Returns a TXLSShapes object that represents the picture and standalone text-box shapes on the Worksheet. Read-only.

Syntax

property Shapes: TXLSShapes;

Example

This example adds a picture to Worksheet one.

Workbook.Sheets[1].Shapes.AddPicture('picture.jpg');
This example adds a standalone text box to Worksheet one.

Workbook.Sheets[1].Shapes.AddTextBox('Text box', 2, 2, 5, 6);
This example deletes any shapes from sheet one.

Workbook.Sheets[1].Shapes.Delete;