Reference>TDataToXLS>VisibleFieldsOnly

Indicates whether to export only the fields that are visible. The default value is False. Read/write Boolean.

Syntax

property VisibleFieldsOnly: Boolean;

This example sets VisibleFieldsOnly property to true.

DataToXLS1.VisibleFieldsOnly := True;