how to use dlmwrite for excel sheet has three columns

I have an excel file which has contain data into three columns. I want to change file type excel into .dat file using dlmwrite command. File type has changed but problem is that three columns data merge into one common. Now how to correct this?

Answer 1

[KSSV]

T = readtable('myexcelfile.xlsx') ;
writetable(T,'out.dat') ;

[Sukhpal Kaur]

When i using the above command for read table the excel file is reduced by one row. for exampe suppose i have 10 rows and three columns then after using readtable command the workspace shows 9 row and three columns instead of 10 and 3. After compliting the whole command it is showing

error using load

unknown text on line no. 1 of ASCII file...... "x"

At the end .dat file is not build.