read multiple excel files in the one line of the code

3 次查看（过去 30 天）

vijay 2012-7-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/44390-read-multiple-excel-files-in-the-one-line-of-the-code

I have a set of folders which contains excel files. But the name of excel files differ from folder to folder but the content in them is same.Its like GAMMA in one folder and GA and GAM in another folder.All three files don't exist in the same folder. Can i give a command to read them in the same line if it exists in the folder which i want to read...

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Yash 2012-7-24

xlsread will read one excel file at a time

请先登录，再进行评论。

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

回答（2 个）

Image Analyst 2012-7-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/44390-read-multiple-excel-files-in-the-one-line-of-the-code#answer_54419

No, not unless you put three xlsread()'s on the same line of code. Why does it need to be one line of code? What's wrong with 3 lines?

3 个评论
显示 1更早的评论隐藏 1更早的评论

Srinivas 2012-7-24

在 MATLAB Online 中打开

may be you can use

try & catch

Image Analyst 2012-7-24

Well you have to write robust code. Sorry about that. You'll need to construct your filename, then call exist(filename, 'file') to check that it actually exists before you call xlsread. Sorry, but robust, bulletproof code can't be written in a single line.

请先登录，再进行评论。