This method returns the name of the current worksheet.

CALL METHOD spreadsheet->get_active_sheet
       EXPORTING no_flush  = no_flush
       IMPORTING sheetname = sheetname
                 error     = error
                 retcode   = retcode.