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

1 次查看（过去 30 天）
Santosh Biradar
Santosh Biradar 2022-8-10
编辑： Stephen23 2022-8-10
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

请先登录，再回答此问题。

回答（1 个）

KSSV
KSSV 2022-8-10
编辑：KSSV 2022-8-10
%% 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));
  4 个评论
显示 2更早的评论
Santosh Biradar
Santosh Biradar 2022-8-10
编辑：Santosh Biradar 2022-8-10
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
Stephen23 2022-8-10
编辑：Stephen23 2022-8-10
"How can I get D:\mydrive\Task8\CompareSummary\abc_2022_Result.xlsx using XlFile ..."
new = fullfile(xlFile(1).folder,xlFile(1).name)

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by