MATLAB: Merge path and filename for xlswrite

filenamemergepathxlswrite

Hi all,

I would like to save an excel file which it could be already created or not to a dynamic path with a specific filename. I mean that the path where the file may be written is modified each time the code is executed but the name of the file remains the same.

I've tried this..

myFolder = 'E:\Dropbox\'; xlswrite(myFolder\'results.xlsx',P,'RSSI lineal',['A' num2str(i+1)]);

It should save the data to the file results.xslx in the path "myFolder".

Thanks a lot.

Raúl.

Best Answer

Code examples for doing that are in the FAQ: http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

Related Solutions

MATLAB: How to combine multiple excel files in a single new excel file

Is D a local disk or a remote network disk? This will go much faster if you save the files locally before trying to read them all.

fileDir = 'D:\excel_folder';
outfile = 'D:\MASTER.xls';
addpath(fileDir);
fileNames = dir(fileDir);
fileNames = {fileNames.name};
fileNames = fileNames(cellfun(...
    @(f)~isempty(strfind(f,'.xls')),fileNames));
for f = 1:numel(fileNames),
    fTable = readtable(fileNames{f});
    writetable(fTable,outfile,'Sheet',filenames{f});
end

Each sheet of MASTER.xls should now have the same name as the file that contained the data.

Hope this helps.

MATLAB: XLSWRITE

name = inputdlg('Name excel file as: ','Name excel',1);

Best Answer

Related Solutions

MATLAB: How to combine multiple excel files in a single new excel file

MATLAB: XLSWRITE

Related Question