I want to select an Excel file by it's extension

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

Answer 1

[KSSV]

%% 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));

[Santosh Biradar]

Hi @KSSV

It is still reading the path, not the file.

in result it is showing,

FilePath = '\CompareSummary\*.xlsx'

I need

FilePath = '\CompareSummary\abcResult.xlsx'

[KSSV]

YOu have to use dir to get the file name. Edited the code.

[Santosh Biradar]

Hi @KSSV

Previously, I am using FilePath to read abc_2022_Result.xlsx.

How can I get

D:\mydrive\Task8\CompareSummary\abc_2022_Result.xlsx

using XlFile or NEW variable.

[~,sheets] = xlsfinfo(fullfile(xlFile(1).folder,xlFile(1).name));

Here can I get excel file address?

sheets showing the worksheet presnt in abc_2022_Result.xlsx correctly but getting problem with it's address reading pattern.

xlFile =

struct with fields:

name: 'abc_2022_Result.xlsx'

folder: 'D:\mydrive\Task8\CompareSummary'

date: '10-Aug-2022 14:50:33'

bytes: 34137

isdir: 0

datenum: 7.3874e+05

How can I get

D:\mydrive\Task8\CompareSummary\abc_2022_Result.xlsx

[~,sheets] = xlsfinfo(fullfile(xlFile(1).folder,xlFile(1).name));

can I get excel file New variable.?

Thank you

[Stephen23]

"How can I get D:\mydrive\Task8\CompareSummary\abc_2022_Result.xlsx using XlFile ..."

new = fullfile(xlFile(1).folder,xlFile(1).name)