Change path of where the excel files are store and run the code
8 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Devarshi Patel
am 7 Jun. 2019
Beantwortet: Walter Roberson
am 7 Jun. 2019
Hello,
I want the user to run the matlab code from its original directory but running it through the excel files that are located in different directory. For example, if matlab code is stored in C:/user/documents and user selects the excel file to be in C:/user/data/excelfiles, I want the code to go through excelfiles folder and run through those files. I have already tried uigetfile to run the code through user selected path. This is not working out as the code still tries to run through its original directory. (Also excel files are too big to load them to matlab.)
[filenames,path] = uigetfile({'*.csv'},'Select the INPUT DATA FILE(s)','MultiSelect','on');
filename1 = strcat(path,filenames);
Code I am currently using to change the path of the files.
0 Kommentare
Akzeptierte Antwort
Walter Roberson
am 7 Jun. 2019
[filenames, filepath] = uigetfile({'*.csv'},'Select the INPUT DATA FILE(s)','MultiSelect','on');
if isnumeric(filenames); return; end %user cancel
filenames = cellstr(filenames); %in case the user selected only one entry
filenames = fullfile(filepath, filenames);
numfile = length(filenames);
for K = 1 : numfile
thisfile = filenames{K};
thisdatatable = readtable(thisfile);
......
end
0 Kommentare
Weitere Antworten (1)
Adam Danz
am 7 Jun. 2019
Bearbeitet: Adam Danz
am 7 Jun. 2019
This will store the full path to all selected files as strings in a cell array. You can then loop through the cell array to act on each selected file. Is that what you're looking for?
[filenames,path] = uigetfile({'*.csv'},'Select the INPUT DATA FILE(s)','MultiSelect','on');
allFilesFullPath = fullfile(path,filenames);
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!