When importing data from Excel 2007 and above with Toad installed using Oracle 9.x client and below, no data is displayed in preview pane. Not even column names.
Workaround 1:
Change Excel file extension from .xlsx to .xls
Workaround 2:
Upgrade Oracle client to the latest version.