Hi Satya,
You need to first read the data from the excel sheet into a variable using xlsread and then save it into a .dat file using the save command as shown below:
>> read_data = xlsread('filename.xlsx');
>> save 'data.dat' read_data -ASCII;
Now you can refer to the following link that demonstrates how to use the Technical Analysis functions:
