Skip to Content

how to hide or delete excel sheet when export multiple sheet export from sap abap

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers