Convert multiple csv to xls files.

Question

avantika 2013-10-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/103299-convert-multiple-csv-to-xls-files

评论： Marcos dos Santos 2021-4-16

Hi!

I have a folder containing many excel files ( more than 200) in csv format . I need to write all these files in xls format.

Can this be done in matlab . Can anyone please help.

Thanks in advance

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Azzi Abdelmalek 2013-10-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/103299-convert-multiple-csv-to-xls-files#answer_112642

编辑：Azzi Abdelmalek 2013-10-25

在 MATLAB Online 中打开

yourfolder='E:\matlab'
d=dir([yourfolder '\*.csv']);
files={d.name};
for k=1:numel(files)
   old_name=files{k}; 
   [~,~,b] = xlsread(old_name) ;
   new_name=strrep(old_name,'csv','xls')
   xlswrite(new_name,b);
end

7 个评论
显示 5更早的评论隐藏 5更早的评论

Walter Roberson 2018-6-1

在 MATLAB Online 中打开

More correct would be

yourfolder = 'E:\matlab'
d = dir(fullfile(yourfolder, '*.csv'));
files = {d.name};
for k=1:numel(files)
 old_name = files{k}; 
 [~,~,b] = xlsread( fullfile(yourfolder, old_name)) ;
 new_name = strrep(old_name,'csv','xls')  
 new_folder = 'E:\another'
 new_file = fullfile(new_folder, new_name)
 xlswrite(new_file,b);
end

Onur ALPAY 2020-12-8

Hi,

I am using MATLAB 2019a version and it looks there is no problem with version. I try this code but I realized that the below code doesn't work. It gives me the same file name. Do you have any experiance about that?

new_name = strrep(old_name,'csv','xls')

请先登录，再进行评论。

Answer 2

Fabian Neira 2018-6-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/103299-convert-multiple-csv-to-xls-files#answer_322857

I got the following error "File name must be a character vector" when using the code.

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

Walter Roberson 2018-6-1

Please post your code.

请先登录，再进行评论。

Answer 3

Lotan Jackson 2020-8-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/103299-convert-multiple-csv-to-xls-files#answer_484841

在 MATLAB Online 中打开

Hi everyone, I know this is an old question but I had to adjust things for either the newest version or being on a newest matlab version. Here's the code. I placed all the files in the folder with the script.

file = dir('*.csv'); 
s= size(file,1);
for i= 1:s
    Data = readtable(file(i).name);
    filename=file(i).name;
    filename= filename(1:end-5); 
    writetable(Data,[filename '.xls']);
end;