tags:

views:

14

answers:

0

I want to delete a worksheet if it contains no data/charts/images/drawing/hyperlink object or any other embedded objects.

I find out the solution of detecting and deleting blank sheets if there is no data in the cells by using the following code:-

if ( $Worksheet_Function->CountA( $sheet->{Cells} ) == 0 ) { $sheet->Delete; }

but it also deletes the sheet if there are charts or non-text objects.

Is there any way to identify and delete sheets if its completely empty?