Question: how to import excel file in datastage?
Answer: In Microsoft Excel Item, you can select the item you want to map to the InfoSphere DataStage column. All items that can be selected in the Import pane are listed in each cell. In Import Option, you can select the Microsoft Excel item if there is any import options available.