Reference>IXLSRange>Hidden :: Delphi + Excel

True if the rows or columns are hidden. The specified range must span an entire column or row. Read/write OleVariant.

Syntax

property Hidden: OleVariant;

This example hides column C on sheet one.

Workbook.Sheets[1].Range['A1', 'A1'].EntireColumn.Hidden := True;

This example hides row 5 on sheet one.

Workbook.Sheets[1].Range['A5', 'A5'].EntireRow.Hidden := True;