Question: how to extract data from excel in informatica?
Answer: b) Click on Insert> Name> Define option.
c) Type the name of the range and select the range on “Refers to:” space.
d) Save the spreadsheet, Normally this kind of sources are saved in a specific folder (\Informatica\PowerCenter8. ... 
c) Click on Add and choose Microsoft Excel Driver (*.