A very useful link for setting up data from Excel add-ins:

Importing Data to AX 2012 Using Excel Add-ins

Happy Daxing