I'm getting the error "Name is not of requested type" by using xlsx files (Excel 2007).
Here's the code snippet where i get the error message:
lCol := xlsImport.InternalNames.Items[lIndex].Col1
if I save the imported excel file in file format xls, and restart, the import works without problems.
I'm using version 4.00.15.
What's the problem with using xlsx file format?