how to hide or delete excel sheet when export multiple sheet export from sap abap
CALL METHOD OF application 'Worksheets' = iv_sheet
EXPORTING #1 = 'Sheet2'.
CALL METHOD OF iv_sheet 'visible'.
SET PROPERTY OF iv_sheet 'VISIBLE' = 2.
CALL METHOD OF application 'Worksheets' = iv_sheet
EXPORTING #1 = 'Sheet1'.
CALL METHOD OF iv_sheet 'visible'.
SET PROPERTY OF iv_sheet 'VISIBLE' = 2.
CALL METHOD OF application 'Worksheets' = iv_sheet
EXPORTING #1 = 'Sheet3'.
CALL METHOD OF iv_sheet 'visible'.
SET PROPERTY OF iv_sheet 'VISIBLE' = 2.
i have use this code but not working
