HIDDEN subcommand (GET DATA command)

For TYPE=XLSX and TYPE=XLSM, the HIDDEN subcommand controls the treatment of rows and columns that are hidden in the Excel file.

IGNORE=NO

Hidden rows and columns are included. This setting is the default.

IGNORE=YES

Hidden rows and columns are excluded.

This subcommand is not valid for TYPE=XLS.