Clear Filters
Clear Filters

Unable to use xlsread to open a file

1 view (last 30 days)
Hey everyone,
I'm trying to run the follwing code:
for i=1:10
fil_length= xlsread('\\some_pathway_here\Filament_Length_Data\Filament_Length_',num2str(i),'.xls')
end
However, I get an error: Error using xlsread (line 132)
XLSREAD unable to open file '\\some_pathway_here\Filament_Length_Data\Filament_Length_'.
File '\\some_pathway_here\Filament_Length_Data\Filament_Length_' not found.
When I run this code:
fil_length= xlsread('\\some_pathway_here\Filament_Length_Data\Filament_Length_1.xls')
without the num2str(i) part, I'm able to read the file. Is it not possible to run a function such as this? If not, are there any other ways that i could access my excel files inside a loop?
  1 Comment
Meghana Balasubramanian
Meghana Balasubramanian on 28 Aug 2019
My apologies, I realized i made an error with using the brackets. It should be:
for i=1:10
fil_length= xlsread(['\\some_pathway_here\Filament_Length_Data\Filament_Length_',num2str(i),'.xls'])
end

Sign in to comment.

Accepted Answer

Bruno Luong
Bruno Luong on 28 Aug 2019
for i=1:10
fil_length= xlsread(['\\some_pathway_here\Filament_Length_Dat\Filament_Length_' num2str(i) '.xls'])
end

More Answers (1)

darova
darova on 28 Aug 2019
2Untitled.png
  1 Comment
Walter Roberson
Walter Roberson on 28 Aug 2019
No, initial \\ in Windows indicates a path for network access, and is proper.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!