I want to select an Excel file by it's extension
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Hi
%% Here only 1 Excel file will be present in ComparySummary folder. And I want select that Excel file with FilePath %%
FilePath = fullfile(pwd,'\CompareSummary\*_*.xlsx');
[~,sheets] = xlsfinfo(FilePath);
But, It is not idenfying *_*, as I am putting it into single quotation marks ' '.
Please let me know what change shall I do here?
Thank you
Please let me know for brief
0 comentarios
Respuestas (1)
KSSV
el 10 de Ag. de 2022
Editada: KSSV
el 10 de Ag. de 2022
%% Here only 1 Excel file will be present in ComparySummary folder. And I want select that Excel file with FilePath %%
FilePath = fullfile(pwd,'\CompareSummary\*.xlsx');
xlFile = dir(FilePath) ;
[~,sheets] = xlsfinfo(fullfile(xlFile(1).folder,xlFile(1).name));
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!