fileID = fopen(filename,permission) opens the file with the type of access specified by permission.

Have you tried "help fopen" ?

Yes, I know that. It will create a file with our format. But I don't want to write the filename manually. Instead I want the same name as excel. If I have 10 excel files. Then I will use a loop to create a txt file with the same name.

% Select folder where all input excel files are stored

dirname = uigetdir(' ','Select folder where excel files are stored');

% Select folder where you want to save your output

oname = uigetdir(' ','Select folder to save output');

% Concatenate path with required filename extension

pathname = strcat(dirname,'\*.xls*');

% List of all -xls files in given folder

file_list = cellstr(ls(pathname));

for i1 = 1:length(file_list)

[~,fname,ext] = fileparts(char(file_list(i1)));

%%% Do your processing %%%

outfilename = strcat(oname,'\',fname,'.txt');

fid = fopen(outfilename,'a');

%%% Do your writing to the file %%%

fprintf(fid,'Hello World\r\n'); % example

fclose(fid);

end

@Ruchit: Thanks for your code. But I get the error 'Input must be a row vector of characters' in the fileparts line.

Hi Praveen, I have modified the code. It worked for me. It should be fine now.

@Ruchit Thank you so much. So kind of you to explain everything in steps.