How to use ms excel file in datastage?

Firstly the first row in excel file should have column names. After you prepared your excel file with the data you want to be loaded in to the table, Convert the excel file to CSV format. Then using WINSCP tool i.e SFTP file transfer you can transfer the CSV file from local system to the server.

Secondly after transferring you can access the CSV file in datastage by using sequential file.Open the sequential file and map or locate the CSV file.

Finally you can compile and run the job.