https://community.sap.com/t5/application-development-and-automation-discussions/how-to-hide-or-delete-excel-sheet-when-export-multiple-sheet-export-from/m-p/400694#M10232 <P>how to hide or delete excel sheet when export multiple sheet export from sap abap</P><P>CALL METHOD OF application 'Worksheets' = iv_sheet<BR /> EXPORTING #1 = 'Sheet2'.<BR /> CALL METHOD OF iv_sheet 'visible'.<BR /> SET PROPERTY OF iv_sheet 'VISIBLE' = 2.<BR /> <BR /> CALL METHOD OF application 'Worksheets' = iv_sheet<BR /> EXPORTING #1 = 'Sheet1'.<BR /> CALL METHOD OF iv_sheet 'visible'.<BR /> SET PROPERTY OF iv_sheet 'VISIBLE' = 2.<BR /> <BR /> CALL METHOD OF application 'Worksheets' = iv_sheet<BR /> EXPORTING #1 = 'Sheet3'.<BR /> CALL METHOD OF iv_sheet 'visible'.<BR /> SET PROPERTY OF iv_sheet 'VISIBLE' = 2.</P><P>i have use this code but not working</P> Thu, 02 Feb 2017 10:23:51 GMT former_member354305 2017-02-02T10:23:51Z https://community.sap.com/t5/application-development-and-automation-discussions/how-to-hide-or-delete-excel-sheet-when-export-multiple-sheet-export-from/m-p/400694#M10232 <P>how to hide or delete excel sheet when export multiple sheet export from sap abap</P><P>CALL METHOD OF application 'Worksheets' = iv_sheet<BR /> EXPORTING #1 = 'Sheet2'.<BR /> CALL METHOD OF iv_sheet 'visible'.<BR /> SET PROPERTY OF iv_sheet 'VISIBLE' = 2.<BR /> <BR /> CALL METHOD OF application 'Worksheets' = iv_sheet<BR /> EXPORTING #1 = 'Sheet1'.<BR /> CALL METHOD OF iv_sheet 'visible'.<BR /> SET PROPERTY OF iv_sheet 'VISIBLE' = 2.<BR /> <BR /> CALL METHOD OF application 'Worksheets' = iv_sheet<BR /> EXPORTING #1 = 'Sheet3'.<BR /> CALL METHOD OF iv_sheet 'visible'.<BR /> SET PROPERTY OF iv_sheet 'VISIBLE' = 2.</P><P>i have use this code but not working</P> Thu, 02 Feb 2017 10:23:51 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-hide-or-delete-excel-sheet-when-export-multiple-sheet-export-from/m-p/400694#M10232 former_member354305 2017-02-02T10:23:51Z