Create the DSN entry as shown below.
Create the report in SQL Server Data Tools, Create Data Source as shown below
Create the DataSet by using below query.
Select * From [Sheet1$]
From here you can create Report as you like as fields will be available in data-set.