Converting .xls and .xlsx to .csv

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!

Answer 1

[Image Analyst]

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

[Ali]

great! How about if we have number and text in our excel file?

[Image Analyst]

You can make up a cell array and use xlswrite(). Or you can make a table and use writetable().

[Ali]

Thanks a lot. I used xlswrite() and It was the solution.

[Vikas Saroha]

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

[Image Analyst]

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

Answer 2

[Harish TV]

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---------------------']);

Answer 3

[sapna kumar]

file = dir('*.xlsx'); % make sure your are navigated to the right folder on matlab

s= size(file,1);

for i= 1:s

Data = xlsread(file(i).name);

filename=file(i).name;

filename= filename(1:end-5); % to remove extension from filename

csvwrite([filename '.csv'], Data);

end