MATLAB Answers

how to use dlmwrite for excel sheet has three columns

조회 수: 4(최근 30일)
Sukhpal Kaur
Sukhpal Kaur 28 Nov 2019
Commented: Sukhpal Kaur 28 Nov 2019
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?

  댓글 수: 0

로그인 to comment.

답변 수 (1)

KSSV 28 Nov 2019
T = readtable('myexcelfile.xlsx') ;
writetable(T,'out.dat') ;

  댓글 수: 1

Sukhpal Kaur
Sukhpal Kaur 28 Nov 2019
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.

로그인 to comment.

이 질문에 답변하려면 로그인을(를) 수행하십시오.


Translated by