Read workbook activity has been included to Excel automation so you should now be able to use this activity to get the sheet names from an excel file.