HotXLS Docs
Main Index Overview

Shapes property

Yields 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', 2, 2);
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;