Question: how to import excel file in obiee 11g?
Answer: Open up your ODBC Data Sources.
Select the driver you want to use.
Name your ODBC Data Source.
Select your workbook.
In the Admin tool, go to File -> Import (10g) and select your data source. ... 
Import that file/folder.
What you'll have in your physical layer is this: