convert xls to txt without column names

Question

sai prasanna sai prasanna m s 2022-11-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1853688-convert-xls-to-txt-without-column-names

回答： Aritra 2022-11-21

I am trying to convert a set of xls files into txt files.

I do not have any names for the columns. But the converted text files have the column names appearing as var1 var2 so on...

I just want to copy the data from xls file to txt file without any column name, with space as delimiter.

Current output:

var1 var2 var3

11 12 13

21 22 23

31 32 33

Output that I want:

11 12 13

21 22 23

31 32 33

I am trying with the following code:

files = dir('*.xls'); 
for i=1:length(files) 
    data=readtable(files(i).name) 
    [filepath,names,ext] = fileparts(fullfile(pwd,files(i).name)); 
    writetable(data,names, 'Delimiter',' '); 
end

3 个评论
显示 1更早的评论隐藏 1更早的评论

sai prasanna sai prasanna m s 2022-11-17

Sorry, I meant xls file, as I had mentioned in my title. I have edited my question now.

Stephen23 2022-11-17

Use READMATRIX and WRITEMATRIX.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Aritra 2022-11-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1853688-convert-xls-to-txt-without-column-names#answer_1106508

在 MATLAB Online 中打开

Hi,  

As per my understanding, you are trying to copy the data from ‘.xls’ file to ‘.txt’ file without any column headings and having space as delimiter.

You can set the WriteVariableNames indicator to false in the writetable(T) function.

files = dir('*.xls'); 
for i=1:length(files)  
    data=readtable(files(i).name); 
    [filepath,names,ext] = fileparts(fullfile(pwd,files(i).name));  
    writetable(data,names, 'Delimiter',' ','WriteVariableNames',0);  
end 

For detail, please see this MathWorks documentation below for more information on ‘writetable’:  https://in.mathworks.com/help/matlab/ref/writetable.html