Converting .xls and .xlsx to .csv

Question

mike 2014-12-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/165743-converting-xls-and-xlsx-to-csv

评论： Image Analyst 2020-7-22

Hey guys,

I was wondering if there was a way I could ask a user if their file is .csv, and if not, I would sent it through a loop to have it converted to .csv. Is there any way I could do that?

Thanks!

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

请先登录，再进行评论。

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

Answer 1

Image Analyst 2014-12-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/165743-converting-xls-and-xlsx-to-csv#answer_161561

编辑：Image Analyst 2014-12-7

在 MATLAB Online 中打开

Why not assume the extension is correct and process it if necessary?

[folder, baseFileName, extension] = fileparts(filename);
if strcmpi(extension, '.xlsx')
  numbers = xlsread(filename);
  csvFileName = strrep(filename, '.xlsx', '.csv');
  csvFileName = strrep(csvFileName, '.xls', '.csv');
  csvwrite(csvFileName, numbers);
end

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

Vikas Saroha 2020-7-22

But it writes only numbers not including row and colomn headers. How these can be included in the .csv file?

Image Analyst 2020-7-22

You can use fprintf() to write it out exactly as you want.

请先登录，再进行评论。

Answer 2

Harish TV 2017-3-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/165743-converting-xls-and-xlsx-to-csv#answer_259162

clear; clear all; fileip='filename.csv'; g=char(fileip); g=g(1:end-4) fileop=horzcat(g,'.xlsx') g=fileip(1:end-4); [~,~,F]=xlsread(fileip); F=cellstr(F); %delete the header rows (4 rows) F([1:4],:)=[]; for a=1:size(F,1); b=F(a,1); c=char(b); D(a,:)=strsplit(c,','); end xlswrite(fileop,D); disp(['--------------Process complete---------------------']);